ANSI databases with esqlc

I believe that with ANSI, if you are not the owner of the table, you must precede the name of the table with the owner. This could be your problem. Mike Ballentine --------------------------( Forwarded letter 1 follows )--------------------- Date: Friday, 18 April 1997 2:47pm From: Kate_Tomchik@homedepot.com Received-Date: Fri, 18 Apr 1997 15:17:00 -0400 X-Lotus-Fromdomain: THDPROD To: informix-list@rmy.emory.edu Date:Fri, 18 Apr 1997 14:17:05 -0500 Subject: ANSI databases with esqlc Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Sender: informix-list-owner@rmy.emory.edu Reply-To: Kate_Tomchik@homedepot.com X-Informix-List-Id: <list.14086> We have a simple esqlc program that updates a column in a table. It works fine with all of our standard Informix environments. When we try to run the same program on the ANSI environment, we get the error 243: -243 Could not position within a table table-name. What do we need to do to make this work in the ANSI environment?