[aravindu]

Hello All.....

Is there any way to get the affected row count after executing a delete query.

example:

Delete from TBL_NAME where Id=1 returning rows_affected ;

i tried but shows error in query..

Looking for your help..

Thank You.

[joeflinthiggins]

Hello,

You could just take a COUNT using the same WHERE statement before you delete. For example:

SELECT COUNT(*) FROM TBL_NAME WHERE Id=1;

As long as you use the same WHERE statement, that exact number of records will be deleted.

Joe

[tsteinmaurer]

@aravindu: If you are fine doing that in PSQL (stored procedure, trigger, execute block), then check out the ROW_COUNT context variable. Usually, access components like IBObjects, IBDAC ... AFAIK also offers a property which gives you the "rows affected", but this isn't part of the SQL statement then.

@joeflinthiggins: Only when running the SELECT and the DELETE in a single SNAPSHOT transaction.

HTH.