no - all 'export' values = 0 to start

--- In ib-support@y..., "Martijn Tonies" <m.tonies@u...> wrote:
> Hi,
>
> Notice that "(old.export <> 1)" does not care
> about NULL values in the old.export column. Perhaps
> that's your problem?
>
> Martijn Tonies
> InterBase Workbench - the developer tool for InterBase and Firebird
> http://www.interbaseworkbench.com
>
> Upscene Productions
> http://www.upscene.com
>
> "This is an object-oriented system.
> If we change anything, the users object."
>
> >
> > set term ^ ;
> > create trigger trig_routing_export for routing
> > after update as
> > begin
> > if (old.export <> 1) then
> > update routing
> > set export = 1
> > where waybill = new.waybill;
> > end^
> > 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