Subject | Are these triggers still working in FB 2.0? |
---|---|
Author | dr_bentonquest |
Post date | 2009-01-21T16:31:10Z |
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]
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]