[Oracle] getting RowsAffected value
lazarus / 16-Databases

----------------------------------------------------------------------
wht244 · 2010-07-06 09:14

how can i get the RowsAffected value of Insert query?

----------------------------------------------------------------------
stonefull · 2010-07-06 12:30

RowsAffected only works in ZeosLib.

ZQuery1.SQL.Add('INSERT INTO ....');    // or UPDATE
ZQuery1.ExecSQL;
ShowMessage('Rows Affected: ' + IntToStr(ZQuery1.RowsAffected));

----------------------------------------------------------------------
Lacak2 · 2010-07-07 13:06

If you are using sqldb TOracleConnection+TSQLQuery then RowsAffected
is not implemented ... you can report it as a bug, so it can be added.

(OCIAttrGet(, OCI_HTYPE_STMT, , , OCI_ATTR_ROW_COUNT, ))
http://forums.oracle.com/forums/thread.jspa?threadID=1026262&tstart=58

----------------------------------------------------------------------
Lacak2 · 2010-07-09 05:52

http://bugs.freepascal.org/view.php?id=16885