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