SQLDB - SQLQUERY
lazarus / 16-Databases

----------------------------------------------------------------------
k1attila1 · 2013-06-06 14:38

Hi

I use SQLQUERY component on SQLDBpalette and  deleteSQL, insertSQL,
updateSQL properties.

I use it with dataaccess and dbgrid and dbnavigator componenet.

How can i get the affected rows number after delete,insert,update ?

"Rowsaffected" works only with select select sql !

----------------------------------------------------------------------
Lacak2 · 2013-06-07 05:36

TSQLQuery.RowsAffected is right property.
It should return rows affected by last sql insert/update/delete
statement
But you must execute this statement using TSQLQuery.ExecSQL
See: http://www.freepascal.org/docs-
html/fcl/sqldb/tcustomsqlquery.rowsaffected.html