Re: What is this error?

Path: emory!swrinde!elroy.jpl.nasa.gov!sdd.hp.com!hplabs!pyramid!infmx!news From: cortesi@informix.com (David Cortesi) Newsgroups: comp.databases.informix Message-ID: <1991Dec13.195514.10882@informix.com> Date: 13 Dec 91 19:55:14 GMT References: <1991Dec13.171848.7705@informix.com> Sender: news@informix.com (Usenet News) Reply-To: cortesi@informix.com Organization: Informix Software, Inc. In article <1991Dec13.171848.7705@informix.com> johnl@informix.com (Jonathan Leffler) writes: > In article <1991Dec11.115229.13125@dircon.co.uk> uaa1006@dircon.co.uk (Peter Miles) writes: > > > >I've got an ESQL/C program which is trying to UPDATE a row in > >the database, but it keeps returning with Error number: -522. > > -522: Table (%s) not selected in query.> > Yep, it's missing in my documentation too; I'll notify our documentation > department. We got it, Jonathan. In version 4.1 and after, error message explanations are distributed on the product tape and there is a shell script, $INFORMIXDIR/bin/finderr, which in this case says: % finderr 522 -522 Table (table-name) not selected in query. The table shown appears at some point in this query, but it does not appear in the FROM clause. Review the uses of this name: if it is spelled as you intended, then add it to the FROM clause. It would also appear in the error message manual distributed with products since 4.1.