Subject Trigger not working
Author rodbracher
I have a trigger :

set term ^ ;
create trigger trig_routing_export for routing
after update as
if (old.export <> 1) then
update routing
set export = 1
where waybill = new.waybill;
set term ; ^

Now if I go into IBConsole and edit a load of records on the routing
table by selecting an arbitary column, inserting a valid value then
down arrow - the 'export' field only sometimes changes to 1 ( in the
current situation all the export values started at 0 ). I cannot pick
up a pattern - but obviously for each edit I need export = 1.

I did try 'where waybill = old.waybill' - no difference.

IB ver 6.00
Thanks - Rod