How many records was updated

mariusz · Post by **mariusz** » Mon 25 Jan 2010 21:10

I have the following code

  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

Plash · Post by **Plash** » Tue 26 Jan 2010 08:30

Please use the RowsAffected property.

mariusz · Post by **mariusz** » Tue 26 Jan 2010 19:36

Of course... Probably I had a brain eclipse...

thank you Plash