Page 1 of 1
Rows Affected
Posted: Wed 20 Dec 2006 18:39
by Bill Gage
I noticed in SQL Server's query analizer that it returns the number of rows affected when running an Update statement. Is that possible with the SDAC components? If so, how do I do it? It would save me the extra effort of having to do a count query after an update.
Posted: Thu 21 Dec 2006 16:15
by Jackson
Use the TCustomDADataSet.RowsAffected property to determine how many rows were updated or deleted during the last query operation. If RowsAffected is -1, the query did not update or delete any rows.
Rows Affected
Posted: Thu 21 Dec 2006 19:16
by Bill Gage
Thank you so much I can kiss your feet!
Posted: Thu 22 Mar 2007 16:57
by matej
How can I get info about Affected rows when I execute multiple statements in one TMSQuery.execute? In RowsAffected I get info just about "last" statement.
Thanks for info.
Matej
Posted: Fri 30 Mar 2007 13:47
by Jackson
SDAC doesn't support such functionality.
You can see the number of affected rows only for the last statement in the batch.