Kbase P9564: Select "_field1" "_field2" from pub."_table" fails with column not found error
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
29/01/2003 |
|
Status: Unverified
SYMPTOM(s):
Select "_field1" "_field2" from pub."_table" fails with column not found error
Select * from pub."_table" works
Merant 3.6 ODBC driver
Using the cold Fusion tool to write the query
CAUSE:
The select field is missing comma in between field name
FIX:
Add a comma between each field name to be searched. In the case of multiple tables, the table name is required to be specified on each field separated by period or dot under the select statement. Also need to add comma in between table name in the from statement if the multiple tables are involved.