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!

External Development Forums - Design & Architecture Topics
Forum to discuss designing applications to work with SalesLogix. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to Design & Architecture Topics | New Thread

View: Search:

Author

Thread: 'Talking' to SQL Functions, TSQL, Stored Procedures.

RJ Samp
Posts: 973

'Talking' to SQL Functions, TSQL, Stored Procedures. Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 31 Oct 08 3:35 PM

Am able to run UDF Functions through a Native SQL Connection.....returns a record set of the retrieved scalar Table based on a very complex, recursive, query.

Are their ways to talk to a SQL function? TSQL code? launch a stored procedure?

nMths = GetMonthsFromSQLFunctionNamed(StartDate, EndDate) kinds of stuff.

[Reply][Quote]

Jeff Weight
Posts: 219

Re: 'Talking' to SQL Functions, TSQL, Stored Procedures. Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 01 Nov 08 3:05 AM

With a question like that, you may as well start it off with "Dear Ryan,"

Although, it seems it would work well to build a native SQL connection string and set up a connection using VBScript ADO, and then execute the procedure that way. Does that not work? Or are you trying to find a way to get it to sync?

[Reply][Quote]

Bob (RJ)Ledger
Posts: 1103

Re: 'Talking' to SQL Functions, TSQL, Stored Procedures. Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 02 Nov 08 8:26 AM

Quote:

Originally posted by RJ Samp

Am able to run UDF Functions through a Native SQL Connection.....returns a record set of the retrieved scalar Table based on a very complex, recursive, query.

Are their ways to talk to a SQL function? TSQL code? launch a stored procedure?

nMths = GetMonthsFromSQLFunctionNamed(StartDate, EndDate) kinds of stuff.

Usually doing a SQL "Execute" thru the provider will bypass ALL provider security and let the actul SQL run.. have you tried that approach?

[Reply][Quote]

Phil Parkin
Posts: 819

Re: 'Talking' to SQL Functions, TSQL, Stored Procedures. Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 02 Nov 08 4:54 PM

So you are trying to mix the local variables of your script with SQL Server functions and use the results?

It's not quite as easy as you have described. You will have to build (in script) the exact SQL string to be executed and then execute it, returning a recordset - standard ADO stuff. Use the native SQL connection as you have suggested for maximum performance/flexibility.

At least that's the easiest way I can think of.

Phil

[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 4:31:00 AM