Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003

    Unanswered: Triger For Update Informix Se 7.1

    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

  2. #2
    Join Date
    Aug 2002
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts