Re: Insert Trigger question

In article <66mgho$874@cssun.mathcs.emory.edu>, Bill Weaver <billw@fscorp.com> writes >I've seen this question asked on the list a few times, but I've never seen the >answer. > >We have a client/server application that, to make a long story short, is >inserting >data into the wrong fields of a table. Until we can get an updated version >distributed, we would like to take care of the problem by writing an insert >trigger that calls a stored procedure to update the table so that the values are >in the correct columns (this is what happens when you let an outside consulting >firm write your client/server application!). I've written the trigger/stored >procedure and tested them independently of each other and they work fine. >However, once I call the stored procedure from the insert trigger, I get the >following error: > >SQL statement error number -747. >Table or column matches object referenced in triggering statement. > >How do I fix this? Is there a work around? No, it is a limitaion of Informix.. >-------------------------------------------------------- >Name: Bill Weaver >E-mail: Bill Weaver <billw@fscorp.com> >Date: 12/10/97 >Time: 11:00:54 > >This message was sent by Z-Mail Pro - from NetManage >NetManage - delivers Standards Based IntraNet Solutions >-------------------------------------------------------- > -- David Williams