At 05:26 PM 11/11/2002 -0600, George Smith wrote:

>With FireBird what happens if you are doing an SQL update and you get an
>error or exception. Is there a mechanism whereby you can
>log to error and continue on with the update.
>
>George R Smith

If you're using the DSQL api, you'll get an error on the
update operation. If it's an internal error, your transaction
is damaged beyond repair. If it's a user-level error (e.g.
null in a non-null field) you can correct the problem,
reissue the statement, and commit the transaction. If the
error happens to be "update conflict", reissuing the statement
will not correct the error, but you can commit the transaction
leaving the failing statement undone.


Regards,

Ann
www.ibphoenix.com
We have answers.