return number of affected records after update

[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

[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.

[inageib]

that is great, thanks