Re: I have problem with TRIGGERS on informix on-line v.7

Art S. Kagel wrote: > > rrems@chez.com wrote: > > > > Problem : > > I have made a trigger on an insert table... > > This one, make operation on rows, and insert in this same table..... BUT > > LOOP!!!!!!!!! and don't stop........ > > Can you help me ???? > > Snicker, snicker, giggle, giggle.... ;-} > > OK I'll get serious, sorry. > > Do you mean you defined an INSERT trigger that calls a stored procedure > which, in turn, inserts rows into that same table? If so, no wonder it > LOOPs forever! Each insert the trigger affects causes the trigger to > fire again, ad infinitum! Is this REALLY what you wanted? Please post > the problem statement, not the trigger/procedure code, and someone will > try to recommend another design. > That'll chew up some serious disk space . . . > BTW: If you can determine from the column values whether the inserted > row is an original or generated row you could short circuit the LOOPing > in the stored procedure that performs the additional insert(s). > John Carlson Informix DBA WH Smith, Inc.