Rows Affected

Bill Gage · Post by **Bill Gage** » Wed 20 Dec 2006 18:39

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.

Jackson · Post by **Jackson** » Thu 21 Dec 2006 16:15

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.

Bill Gage · Post by **Bill Gage** » Thu 21 Dec 2006 19:16

Thank you so much I can kiss your feet!

matej · Post by **matej** » Thu 22 Mar 2007 16:57

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

Jackson · Post by **Jackson** » Fri 30 Mar 2007 13:47

SDAC doesn't support such functionality.
You can see the number of affected rows only for the last statement in the batch.