TRIGGER AND ERROR 747

Posted in 1998

RL — Wed, 25 Nov 1998 20:06:51 GMT — source: Informix-list mailing list archive (1991-1998)

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 ?