Subject Are these triggers still working in FB 2.0?
Author dr_bentonquest
Hi there,



I upgraded a DB from FB 1.5 to 2.0 and wonder if a trigger like this is
still working:



CREATE OR ALTER TRIGGER AI_DETALLECAR FOR DETALLECAR

ACTIVE AFTER INSERT

AS

BEGIN

update FACTURAS

set STATUS = 20

where NUMERO=DETALLECAR.FACTURA;

END



I believe what I put in blue is no longer allowed, i.e., if I recompile
this trigger with IBExpert, FB 2.0 complains. Instead of referencing the
FACTURA field with the name of the table (DETALLECAR) I need to use the
new or old keywords.



My question is: should I re-create all triggers where I followed the
TABLENAME.TABLEFIELD approach? I'm not sure if they are working as they
are now, and I can't make any changes to them without changing the table
name to either new or old.



Thanks for any help



[Non-text portions of this message have been removed]