execsql result count?

jdredd · Post by **jdredd** » Fri 04 Mar 2011 16:13

Searched, but didn't find what i needed.. i'm sure tho it has to have been asked.. anyways..

I have an UPDATE query that runs. I need to know how many records it did if possible.

It looks like with ADO, that execsql has a return value.

AlexP · Post by **AlexP** » Mon 07 Mar 2011 09:11

Hello,

To get the number of affected rows you can use the RowsAffected property like:

Code: Select all

  OraQuery1.SQL.Text := 'UPDATE T SET A = ''update'' WHERE B > 1';
  OraQuery1.Execute;
  ShowMessage('Affected Rows: '+IntToStr(OraQuery1.RowsAffected));

jdredd · Post by **jdredd** » Mon 07 Mar 2011 15:48

awesome i will try that out!

Thanks a bunch.