Subject Re: [firebird-support] Re: Insert statement
Author Paul Vinkenoog
Hi,

> I have applications that use try/catch (Borland C++ and Delphi) when inserting data, then I use a case statement (within the catch portion) to catch the specific error that is returned. Since the "ignore" isn't available, I'll just continue to use the the try/catch.

Depending on the data you're going to import, UPDATE OR INSERT may also be of interest to you. Of course this will generate a lot of unnecessary mutations if there are many duplicates. In that case, creating an SP might be the way to go.


Paul Vinkenoog