Subject | Re: [firebird-support] Re: Insert statement |
---|---|
Author | Paul Vinkenoog |
Post date | 2011-02-13T22:46:25Z |
Hi,
Paul Vinkenoog
> 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