TUniConnection.ExecSQL()

[CristianP]

Hello,

In dbExpress I used return value of TSQLConnection.ExecuteDirect() (number of rows that were affected by the execution of the SQL query).
How can I know how many rows were affected after TUniConnection.ExecSQL()?

Best Regards,
Cristian Peta

[AlexP]

Hello,

For the time being, there is no way to retrieve RowsAffected after executing the ExecSQL method of TUniConnection. We will consider the possibility to implement such feature in one of the next versions.
For this purpose, you can use TUniQuery, for example:

Code: Select all

UniQuery1.SQL.Text = 'INSERT INTO TEST VALUES(1)';
ShowMessage(IntToStr(UniQuery1.RowsAffected)); // <-- there will be returned 1 - the number of inserted records