Page 1 of 1

return number of affected records after update

Posted: Thu 25 Nov 2010 21:53
by inageib
Hi,
I wonder if there is a way to return the number of affected records after execute UPDATE SQL without using two SQL on for UPDATE and another for SELECT

in both FB and IB

Thanks

Posted: Fri 26 Nov 2010 07:50
by AndreyZ
Hello,

You can use the RowsAffected property that is used to indicate the number of rows which were inserted, updated, or deleted during the last query operation. For more information please read IBDAC Reference Manual.

Posted: Fri 26 Nov 2010 15:55
by inageib
that is great, thanks