ExecProc doesn't return number of rows affected using Sql Direct mode

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for SQL Server in Delphi and C++Builder
Post Reply
mgorga
Posts: 8
Joined: Fri 12 Jun 2015 10:08

ExecProc doesn't return number of rows affected using Sql Direct mode

Post by mgorga » Fri 15 Nov 2019 08:18

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

Stellar
Devart Team
Posts: 339
Joined: Tue 03 Oct 2017 11:00

Re: ExecProc doesn't return number of rows affected using Sql Direct mode

Post by Stellar » Tue 19 Nov 2019 08:29

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

mgorga
Posts: 8
Joined: Fri 12 Jun 2015 10:08

Re: ExecProc doesn't return number of rows affected using Sql Direct mode

Post by mgorga » Wed 20 Nov 2019 07:12

Good Morning,
I already sent the requested information.

Best regards,
Mario

Stellar
Devart Team
Posts: 339
Joined: Tue 03 Oct 2017 11:00

Re: ExecProc doesn't return number of rows affected using Sql Direct mode

Post by Stellar » Thu 21 Nov 2019 10:49

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.

mgorga
Posts: 8
Joined: Fri 12 Jun 2015 10:08

Re: ExecProc doesn't return number of rows affected using Sql Direct mode

Post by mgorga » Thu 21 Nov 2019 11:05

Thank you,
Mario

Post Reply