rowid in trigger?
Posted in 1997
Phuoc Ho — — source: Informix-list mailing list archive (1991-1998)
Hi All,
Maybe I missed something in the manuals... Is there are way to
reference rowid in a create trigger statement? A messy work
around is to use:
(select rowid from tablex where fieldx = pre.fieldx_value)
I get an error if I use:
pre.rowid or just rowid
Thanks in advance
Phuoc Ho
Example:
create trigger nps_users_updupdate on nps_users
referencing old as pre new as post
for each row (execute procedure add_trigger(user,current,
(select rowid from nps_users where users_code = pre.users_code)));