It would work, but you might rather catch the exception and check it is
a primary key violation or duplicate index (whatever exception you are
expecting to be raised).

It won't get "upset" though, but it is hardly accelerated if it gets
too many exceptions.

By the way, does anyone know if Firebird supports any sort of "insert
if not exist syntax"?

Adam


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

> Would this be a safe way of accelerated input into a TABLE.
>
> TRY
> INSERT INTO TABLE
> EXCEPT
> UPDATE TABLE
> END;
>
>
>
> Would this cause Firebird Server to get upset by having to
> generate exceptions all the time.
>
> Regards,
>
> Robert