Exceptions can be caused by lots of things.

For example, primary key violations, foreign key violations, violations
of unique constraints, even custom exceptions.

ANY basically means that you do not care what caused the error, you
want to run the block of code. It is (generally) not good practice to
simply blanket catch all exceptions, because an exception you did not
anticipate may be raised, and your generic handler may not handle that
scenario well. One exception is for example if you want to log all
exceptions. You may not actually care about the exception other than
logging that it did not work.

Hope that helps
Adam



--- In firebird-support@yahoogroups.com, "robertgilland"
<robert_gilland@b...> wrote:

> Thanks Adam,
>
> Does "WHEN ANY" mean when something untoward happens?
>
> Regards,
>
> Robert.