Re: Triggers exist in V5.00?

Alicia Ray wrote: } } To All, } } Our site is currently responsible for supporting multiple versions } of the Informix database engine including (v5.00, v5.0x, and soon v7.x). } Unfortunately, certain features are not supported across all platforms } and building utilities becomes more inventive than it needs to be. } } We currently use database triggers to perform transactions on multiple } tables (inserts/update/deletes) using Version 5.03. We have been unable } to implement the identical logic on a Version 5.00 database without } receiving syntax errors. } } Does anyone have a definitive answer to when database triggers were } introduced? If introduced after Version 5.00 (which is different } than v5.0x) does anybody know of other utilities that provide the same } capabilities in Version 5.00? } } Thanks in Advance, } Alicia } } -- } ********************************************************************** } Alicia Ray Internet : Alicia.Ray@med.osd.mil } EDS-D/SIDDOMS Phone : 703-845-3807 } 5113 Leesburg Pike } Skyline 4 Suite 800 } Falls Church, VA 22041-3201 } ********************************************************************** Alicia, Triggers were introduced with Version 5.01 of the DB Engines.Stored Procedures were introduced with Version 5.00.The only solution I see is to upgrade your engines to a 5.0x Version. Regards Tolis +---------------------------------------------------------------------+ | V+K Relational Solutions email: tvarnas@compulink.gr | | Deligiorgi 26 tvarnas@orbit.de | | 546 42 Thessaloniki Voice: (30) 31 820270 | | Greece Fax: (30) 31 865463 | +---------------------------------------------------------------------+