Subject different behavior firebird 3.0 RC2
Author Checkmail

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