RE: triggers, rowid, & SP's

Allen wrote: >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). Can you not get it from a select in the stored procedure? Presumably the table(s) concerned have a unique key that you can use to retrieve the rowid? >I want to either insert this rowid in a physical column in another >table or pass it as a parameter to a stored procedure. Personally I would give very strong consideration to adding a serial column to the tables of interest. You will then be able to make use of this in your triggers too. Remember that the handling of rowids changes in V6/7, if memory serves me correctly. >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