4/19/2024 12:30:25 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 ADO specific questions for use with SalesLogix. View the code of conduct for posting guidelines.
|
|
|
|
SQL Server Native Connection, ADO Command, and Parameters
Posted: 09 May 10 10:36 AM
|
SQL Server Native Connection, ADO Command, and Parameters
Does anyone have an example of using ADO CommandText with input parameters and a native SQL Server connection?
? parameters and the SLX OLE DB Provider work fine.....except it has the tremendous additional query overhead of the SECCODE joins for Non ADMIN users.....SLX OLE DB Provider performance for a scan of 100,000+ records is NOT acceptable.
'Named' Parameters like ? or @P1 don't work with the SQL Server 2005 connection, yet.....
any hints?
Maybe a stored procedure command call instead?
SELECT A1.OPPORTUNITYID FROM OPPORTUNITY A1 WHERE OPPORTUNITYID LIKE ?
or the equivalent would be perfect.
Thank you!
RJ Samp |
|
|
|
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!
|
|
|
|
|
|
|
|