3/18/2026 8:43:17 PM
|
| |
| 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 using the SalesLogix OLE DB Provider from external applications (including usage of built-in provider procedures). View the code of conduct for posting guidelines.
|
|
|
|
Issue with SQL Script being opened by a recordset
Posted: 06 Aug 09 9:50 AM
|
Hi,
I have written a script which returns the data needed. It uses table variables and int variables for looping.
This does not seem to work and I have been searching here for an answer.
I think it has to do with the variables themselves and am wondering if there is a "switch" i can flip to allow the variables to work.
In a nutshell my script does this:
declare @tbl table
insert into @tbl
loop through each record in @tbl
update record in @tbl
display @tbl
Not really a complicated script. I tried writing a simple "declare @tmp int set @tmp = 1 select @tmp" which works fine in management studio but not when i inject it into my module.
Anyway any and all help is appreciated.
Thanks,
Ali |
|
|
|
Re: Issue with SQL Script being opened by a recordset
Posted: 06 Aug 09 11:39 AM
|
Go back to the drawing board. You cannot use TSQL like this with the SLXOLEDB provider. You need to use ADO objects to achieve what you are after. Basically:
Get a connection
Retrieve the data you wish to update into a recordset
Look throuhg the recordset and update the appropriate fields
Call Recordset.UpdateBatch()
Timmus |
|
|
| |
|
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!
|
|
|
|
|
|
|
|