5/15/2024 2:31:10 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 using the SalesLogix OLE DB Provider from external applications (including usage of built-in provider procedures). View the code of conduct for posting guidelines.
|
|
|
|
Executing SQL Stored Procedures through SLX Provider
Posted: 31 Mar 09 10:21 AM
|
Greetings
Trying to clarify the use of SQL Stored Procedures called through the SLX Provider. In general, I thought this wasn't "supported" however if one were to call 'exec stored_procedure_name' through the Administrator's Execute SQL function, it may work. Apparently, SLX Support will not provide a definitive answer and more specifically, I'm trying to determine if the Stored Procedure calls, or the subsequent changes to data, will sync out to remote users/offices. Working with another consultant on a web app and they're insisting on using SP's rather than writing and executing the SQL statements directly in the .NET app.
My next steps are to test it out myself but I was hoping to get input from others who have been down this road and can advise.
Appreciate the help! |
|
|
|
Re: Executing SQL Stored Procedures through SLX Provider
Posted: 31 Mar 09 1:49 PM
|
The definitive answer is no, you cannot use SPROCS and have the data synchronize. I suppose you could call .net assemblies in your SPROC that use the OLEDB provider to write to the database. But if you are doing that you should just bypass the SPROC layer altogether as it adds no value.
Your consultant needs to learn to work with the tool. Dictating that they must use sprocs is ludicrous IMO. If they are concerned about security, sql injection, etc. tell them to use parameterize commands and all is well.
Lastly, if you are using 7.2 or higher the data layer has changed drastically. Sage has implemented NHibernate to handle the web client data access. They have also introduced SData which is a RESTful web service layer. If you are having someone build a web app I would stop and reevaluate as you can either use the existing web client infrastructure (build a custom portal) or you can use SData for your data layer. Using SPROCS is a step backwards.
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!
|
|
|
|
|
|
|
|