Re: Re: Trigger question: data values in a AFTER clause

Well, Actually I'm going forward by doing a stored procedure. I just wanted to know if there is a way to access the updated values in the AFTER clause of a trigger. Chucho -----Original Message----- From: John Carlson <jwcarlson1@yahoo.com.invalid> To: informix-list@iiug.org Date: Thu, 23 Sep 2004 22:11:23 -0400 Subject: Re: Trigger question: data values in a AFTER clause On Thu, 23 Sep 2004 18:53:41 -0500, "Jean Sagi" <jeansagi@myrealbox.com> wrote: > > >It is possible to access the values from an update in an AFTER clause of a trigger? > >I could reference the old and new values with a FOR EACH ROW clause of a trigger (using REFERENCING OLD/NEW). > >But when I try to use the old or new values in an AFTER clause informix gives 732 error stating that old and new values only works in the scope of the for each row clause. > >So in the after clause how can I access the values that are being updated?, if it is possible of course (The manual is not very ilustrative on this theme). > >BTW: I'm using IDS 9.3/9.4 > Call a stored procedure, perhaps? JWC Jean Sagi jeansagi@myrealbox.com jeansagi@yahoo.com sending to informix-list