Check if ExecSQL worked?

[lespaul]

Is there a way to determine if the SQL statement executed? I have a process where:

1. Update a table.
2. Update a different table.
3. Record a log entry of who did what

I'm regularly finding that step 1 and 3 worked, but step 2 didn't complete!

So, is there a way to determine if the ExecSQL statement worked properly before continuing?

Thanks!
leslie

 

[lespaul]

PS - I'm using TQuery for all the statements.

 

[towerbase]

The RowsAffected property of TQuery probably gives you what you want.

The Delphi 7 Help says

Inspect RowsAffected to determine how many rows were updated or deleted by the last query operation. If no rows were updated or deleted, RowsAffected has a value of zero. RowsAffected will have a value of –1 if the execution of the SQL statement could not be executed due to an error condition. This latter situation would typically follow the raising of an exception.

Andrew
Hampshire, UK