Page 1 of 1

How many records was updated

Posted: Mon 25 Jan 2010 21:10
by mariusz
I have the following code

Code: Select all

  OraQuery.SQL = "update MyTable set MyColumn=1 where MyColumn=2";
  OraQuery.ExecSql;
How to read, how many records was processed during last update/delete operation (ExecSql)?

I have read about DADataAdapter and Update function, but I have no idea how to use it.

regards
Mariusz

Posted: Tue 26 Jan 2010 08:30
by Plash
Please use the RowsAffected property.

Posted: Tue 26 Jan 2010 19:36
by mariusz
Of course... Probably I had a brain eclipse...

thank you Plash