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.

--- In firebird-support@yahoogroups.com, "munster77054" <munster77054@...> wrote:
>
> Because of one of my domains, I've become FAMILIAR with MySQL. Within this, it has an "INSERT IGNORE" in addition to the standard "INSERT" statement. This command instructs the database engine to attempt the insert, and if it fails, just to continue on to the next INSERT statement. This works well if the record is a duplicate based on the Primary Key, for instance.
>
> I've looked and looked, but can't find an equivalent statement for FIREBIRD (2.1.x). Does anyone know if there is such a thing?
>