Hi all,
I'm not able to get an result value except 0 using the executeUpdate() method on the statement class.
According to documentation https://msdn.microsoft.com/en-us/library/statement.executeupdate.aspx
the method should deliver the updated row count. I've tried a lot of DML commands (insert, delete and for sure update) but never getting any result value except 0. The statements did affect records in all cases.
any clues how to overcome this problem?
I've tried created statements from both Connection and UserConnection class with a lot of kernels.
Does anyone has a solution for that? As workaround I'm using a select @@ROWCOUNT right after the update or delete statement, but I'm not sure if this is the correct way in all cases.
There is a annotation within the description related to stored procedures (SET NOCOUNT ON OFF)
regards
Douglas
*This post is locked for comments
I have the same question (0)
