Re: TRIGGER AND ERROR 747

RL wrote: > > Hi! > > I want to modify the data of a table (TABLE_A) by using > a trigger with insert event on this table (TABLE_A) > > but Informix send me error 747 > Table or column matches object referenced in triggering statement. > > This error is returned when a triggered SQL statement acts on the triggering > table, > > or when both statements are updates, and the column that is updated in the > triggered > > action is the same as the column that the triggering statement updates. > > What I can do to do it with out receive this error message ? > > Could you help me ? You cannot get around this in versions before 7.30. The Informix engineers who designed the trigger interface couldn't imagine why one would want to adulterate the data a user explicitely inserted so they disallowed such things. The restriction was lifted in 7.30. Art S. Kagel