One hint,

the trigger is required because the user can delete the one record, in this case the trigger deletes the referenced too. But if I delete the entire Order, the record will be delete twice. How can I solve this in fb 3?

Hello again,

now I have in FB3 a problem. A stored Procedure should delete some records.

ID     some fields  ID_AUTOINSERT

123    xxx             null

234   xxx             null

255   xxx             266

266   xxx             null

Now there is a trigger after delete in this table who deletes:

 if(old.ap = 69) then

  begin

    delete from tplan_kw_pos where id_autoinsert = old.id;

  end

In this case, FB will delete the record with ID 266 during deleting ID 255 and the other statement intends to delete the record 266 too.

Now in FB 3 RC 2 I get this error message:

can't format message 13:492 -- message file C:\WINDOWS\SYSTEM32\firebird.msg not found.

no current record for fetch operation.

In FB 2.55, FB2.1 this was not a problem.

How can I fix?

Thanks