Guten Tag munster77054,

> 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?

no there is not , and it would be useless in FB
mysql supports this type of compound insert

insert into table (fieldname) values (1)(2)(3);

rolling 3 insert into one statement

so for example if 2 fails 1 and 3 are still inserted using ignore ,
else all three wud fail

in fb as well as mysql
if a single insert statemnent fails it does not affect the previous
and following ones



--
Mit freundlichen Grüssen
Hannes Streicher mailto:HStreicher@...