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!

Architect Forums - ADO General
Forum to discuss ADO specific questions for use with SalesLogix. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to ADO General | New Thread

View: Search:

Author

Thread: Question regarding using T-SQL variables with SLXOLEDB.1 provider.

Ali Youssefi
Posts: 18

Question regarding using T-SQL variables with SLXOLEDB.1 provider. Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 06 Aug 09 9:38 AM

Hi,
I am writing a script that connects to a saleslogix database. I wrote the script out in Management Studio, using a table variable and a couple of int variables.
I do not get an error message but the recordset does not return anything. I have removed all comments from my sql script.
Does SLXOLEDB.1 allow variables?
Thanks,
Ali

[Reply][Quote]

Stephen Redmond
Posts: 190

Re: Question regarding using T-SQL variables with SLXOLEDB.1 provider. Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 07 Aug 09 4:47 AM

Hi Ali,

The OLEDB provider doesn't support "T-SQL" - you can't use "DECLARE". It also doesn't support such processing keywords as "BEGIN/END" or Cursors.

Sorry.

Regards,

Stephen
www.slxmaster.com

[Reply][Quote]

Ali Youssefi
Posts: 18

Re: Question regarding using T-SQL variables with SLXOLEDB.1 provider. Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 07 Aug 09 7:20 AM

Thank you for the reply Stephen. I appreciate the clarification. I'm currently writing my sql logic in the module.
Thanks,
Ali

[Reply][Quote]

Page 1 of 1

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!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 11/22/2024 5:04:18 AM