Kbase P153392: Getting unknown table name error (200) when trying to compile program
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/28/2009 |
|
Status: Unverified
SYMPTOM(s):
When trying to compile a program that queries the _area table for one of two connected database, the compilation fails with errors (200) and (196).
** Unknown table name <table>. (200)
** <program> Could not understand line <number>. (196)
The following section from the program also fails to compile with the same errors: FOR EACH DB1._Area NO-LOCK:
FIND DB1._Areastatus WHERE DB1._Areastatus-Areanum = DB1._Area._area-number .
END.
FACT(s) (Environment):
Windows
OpenEdge 10.1B
OpenEdge Category: Language (4GL/ABL)
CAUSE:
The table name on the left side of the predicate in the FIND statement. i.e. <DBNAME>.<FIELDNAME>. This should have included the table name between the database and field name.
FIX:
Add the table name between the database and field name or remove the database name from the predicate. For example, the following program will compile correctly: FOR EACH DB1._Area NO-LOCK:
FIND DB1._Areastatus WHERE DB1._Areastatus._Areastatus-Areanum = DB1._Area._area-number .
END.
<OR>
FOR EACH DB1._Area NO-LOCK:
FIND DB1._Areastatus WHERE _Areastatus-Areanum = DB1._Area._area-number .
END.