How to determine whether TSQLScript has been successfully executed on
server?
lazarus / 16-Databases

----------------------------------------------------------------------
tatamata · 2016-01-25 08:49

TPQConnection and TSQLScript - is there a way to determine whether the
TSQLScript was successfully executed on server side?

Thanks.

----------------------------------------------------------------------
tatamata · 2016-01-26 20:20

Fro SQLQuery we have RowsAffected that can be used to decied whether
query was executed successfully...I hoped there might be something
similar for SQLScript?
Or try..except is all I can do to verify that the query was executed
successfully? Coudl TPQEventMonitor be used for that?

----------------------------------------------------------------------
balazsszekely · 2016-01-26 20:31

Quote@tatamata
Fro SQLQuery we have RowsAffected that can be used to decied whether
query was executed successfully...I hoped there might be something
similar for SQLScript?
Or try..except is all I can do to verify that the query was executed
successfully? Coudl TPQEventMonitor be used for that?
You have the OnException event:
QuoteException(Sender: TObject; Statement: TStrings;  TheException:
Exception; var Continue: boolean); For example:
"update people set age = 15;" //<--end statement, the terminator is
";"
You can react to each statement's exception, with the choice to
break/continue the operation(see var Continue)