Re: sqlca.sqlcode error -522
In <1992Oct7.202905.1988@advtech.uswest.com> yslas@riverauswest.com ( Rob Yslas) writes:
>Does anyone know what this error code description is it's not in my ESQL/C
>Informix manual.
TechInfo # 97
Long Description:
Error 522 is generated when you reference a table in the where
clause that is not used in the select statement.
select * from customer where tab.customer = value
TechInfo # 2049
Long Description:
-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.
--
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
William Daul Advanced Support INFORMIX SOFTWARE INC.
4100 Bohannon Dr. (415) 926-6488 - wk
Menlo Park, CA. 94025 uunet!infmx!billd or billd@informix.com