11/26/2024 5:25:45 AM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss writing script in Architect plugins for SalesLogix & general SalesLogix customization topics (for Windows client only). View the code of conduct for posting guidelines.
|
|
|
|
Vbscript
Posted: 27 Jun 06 2:47 AM
|
fiogf49gjkf0d In legacy script after retrieving the record form database one of the colomn has been set using DBSetKeyField.
Eg: TblH = DBOpenSQL("Select * from CLSCLIENT_PRODUCT where ACCOUNTID = '" & Application.BasicFunctions.CurrentAccountID & "' order by PRODUCT_CODE", True)
DBSetKeyField TblH, "CLSCLIENT_PRODUCTID"
Dummy = DBMoveTo(TblH, "First")
What is DBSetKeyField in vbscript? |
|
|
|
Re: Vbscript
Posted: 27 Jun 06 8:53 AM
|
fiogf49gjkf0d This function allows you to set the key that is used to access the data in the recordset. |
|
|
|
Re: Vbscript
Posted: 27 Jun 06 11:30 AM
|
fiogf49gjkf0d There is no direct translation for DBSetKeyField in VBScript. In legacy this was used to spcify the key field for an open handle that would then apply to further operations on that handle. In VBScript you are using straight ADO, nothing more. So in VBScript you are no longer opening handles and using functions such as DBOpenSQL, DBMoveTo, etc. Now you will be using Recordsets and Connections to accomplish the same using the objects provided in ADO.
What exactly are you trying to accomplish in the VBScript? Let us know so we can help you with what you would do to accomplish that with ADO. |
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|