Re: Problem with Insert Triggers

In article <DCCwFy.MLG@scopus.com>, infosoft@scopus.com says... >Apparently, Informix insert triggers (unlike Sybase's and Oracle's) do >not allow an update on any column of the triggering table (ie., an insert >trigger cannot trigger an update of the same table). True observation. One way we worked around it (and I agree it's ugly, but that does has a certain aesthetic appeal as an appropriate workaround for this feature :-) was to insert the row we wanted to manipulate with a certain status. At regular intervals (eg, every minute or two), we run a script that selects all records with this status; updating the status to a "finished" status code, and updating the fields we wanted to update to the values we needed. It isn't pretty, but it works. -- William Harris william@carsinfo.com CARS Information Systems http://www.carsinfo.com/~william/ 4000 Executive Park Drive Cincinnati, OH (USA) 45241