triggers, rowid, & SP's

Posted in 1995

Allen W. Jantzen — Mon, 25 Sep 1995 18:12:15 GMT — source: Informix-list mailing list archive (1991-1998)

Does anyone have any clue how I can "grab" the rowid in the body of a trigger? (What I mean is the rowid of the row that is associated with the firing of the trigger). I want to either insert this rowid in a physical column in another table or pass it as a parameter to a stored procedure. Informix 5.01UC3 is telling me that theres no such row, but its in all tables as a virtual column. Any help greatly appreciated - please respond to: allenj@ndr.com thanks! A rattled informix DBA