Re: After Insert Trigger
Jon,
Try this on the insert trigger:
for each row (
execute procedure get_time() into table.column)
Jason
On Fri, 6 Feb 1998 13:54:45 -0000, "Jon Brown" <jbrown@deverill.co.uk>
wrote:
>Can anyone offer advice?
>
>We are developing a large client server system with an Informix back end.
>Each of the tables in the database has a lastupdated and bywhom field which
>we had invisioned setting by use of an 'after Insert/Update' Trigger.
> (i.e.)
>CREATE TRIGGER post_insert>INSERT ON tablename
>REFERENCING NEW AS NEW_INS
>FOR EACH ROW ( NEW_INS.lastupdated = CURRENT;
> NEW_INS.bywhom = USER);
>
>
>It would appear that it is impossible to update an informix table with a
>trigger that is on the same table
>Is this the case or are we just being stupid?
>
>Thanks
>
>Jon
>
>