> I thought that may invoke an infinite loop - since I'm doing an
> update on an on update trigger - I'll check it out.

Eh, in the BEFORE trigger it should work... In the AFTER trigger,
I think you're doing a loop when you're updating like you are.

Setting the values from WITHIN the trigger doesn't cause loops,
performing an UPDATE in the trigger will fire the trigger again.

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."

> --- In ib-support@y..., "Martijn Tonies" <m.tonies@u...> wrote:
> > Why don't you just do:
> >
> > new.export = 1
> >
> > Seems to have the same effect ...
> >
> > 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."
> >
> >
> > > 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
> > >
> > >
> > >
> > > To unsubscribe from this group, send an email to:
> > > ib-support-unsubscribe@e...
> > >
> > >
> > >
> > > Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
> > >
> > >
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>