Hello,
I am executing a stored procedure that affects one row. I use this compare "SQLStoredProc.ExecProc > 0" to detect if it successfully executed. When the connection is made throw vendorLib "sqloledb" or "msoledbsql" I get value 1 as affected rows. Although, If I connect using Direct connection it returns 0.
I am using Sql Server 2017, dbexpsda40.dll version 8.0.2.0 and Delphi XE6. Is it necessary to configure something to get the return value of ExecProc?
Best regards,
Mario
ExecProc doesn't return number of rows affected using Sql Direct mode
Re: ExecProc doesn't return number of rows affected using Sql Direct mode
Unfortunately, we can't reproduce the issue. To investigate this behavior of dbExpress Driver for SQL Server, please compose a small sample demonstrating the issue and send it to us, including database objects creating scripts.
You can send the sample using the contact form at our site: devart.com/company/contactform.html
You can send the sample using the contact form at our site: devart.com/company/contactform.html
Re: ExecProc doesn't return number of rows affected using Sql Direct mode
Good Morning,
I already sent the requested information.
Best regards,
Mario
I already sent the requested information.
Best regards,
Mario
Re: ExecProc doesn't return number of rows affected using Sql Direct mode
Thank you for the information.
We have fixed the issue, and the fix will be included in the next Devart dbExpress driver for SQL Server build.
We have fixed the issue, and the fix will be included in the next Devart dbExpress driver for SQL Server build.