4/27/2024 12:32:15 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 general external development topic (related or not to SalesLogix development). View the code of conduct for posting guidelines.
|
|
|
|
TSQL to SLX Provider..... any way?
Posted: 21 Nov 08 11:49 AM
|
Bottom Line on this.....is there ANY way to talk from a stored procedure, et al to the provider, insert/update records and have TEFS generated? Some developers are giants in TSQL and feel more comfortable programming in it than VB Script, Cypress Enable Basic, VB, C# .NET....like my boss.
Linked Servers, pass SQL Inserts into a table, have an SLX compatible job run against the table, etc......
|
|
|
|
Re: TSQL to SLX Provider..... any way?
Posted: 22 Nov 08 7:39 AM
|
RJ I cannot believe this could be possible since the proc is parsed and run at the server level and outside the scope of the provider. From the SP would be even harder as I do not suspect that there is a COM interface for such a process that can be invoked.
Mark |
|
|
| |
|
Re: TSQL to SLX Provider..... any way?
Posted: 25 Nov 08 1:14 AM
|
The only way you could do this is to create an OLEDB/ADO connection *inside* the T-SQL. Really not the best idea, or even a good one, but it is doable. You'd create the ADO connection via COM just like you do in anything else. You'd need the code just like you do in VBScript, complete with connection string and then create the ADO objects using sp_OACreate.
Like I said, not really a good idea (not exactly "bad" either, just ugly), but doable if someone really wanted to. |
|
|
|
Re: TSQL to SLX Provider..... any way?
Posted: 26 Nov 08 7:55 PM
|
IMO it is simple to teach someone how to write data into SalesLogix using VBScript. You pick one style, I use Recordset.Update, and then it is simply a case of copy and paste, change the sql, change the fields names, and you are done. I would steer clear of trying to surpass ADO.
It is the folks that know VBScript but not SQL that have a tougher time in my experience...
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!
|
|
|
|
|
|
|
|