ExecProc doesn't return number of rows affected using Sql Direct mode
Posted: 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
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