I'm a newsbie on INFORMIX SE 7.1 and I want to create a TRIGGER ON UPDATE. In a table I'd like to update a field (name of user wich post the update). To identify the record wich is update, in MS SQL2002 I use the syntax FROM DELETED
I see tah didn't work with Informix SE 7.1. Is there another possibility to identify the record wich is update ?
Thanks a lot !
Tabacaru Teodor,
Ragusa ITALIA

You can specify OLD as and NEW as:

so OLD.primary_key would point to the current record. If that's what you want to do.
7.1 is an old version. I see that you use the latest of MS, I would suggest to do the same for informix... It helps.