PRB: "SQL Column Not Found" with Macro Substitution in SELECT (118554)
The information in this article applies to:
- Microsoft Visual FoxPro for Windows 3.0
- Microsoft FoxPro for Macintosh 2.5b
- Microsoft FoxPro for Macintosh 2.5c
- Microsoft FoxPro for Windows 2.5
- Microsoft FoxPro for Windows 2.5a
- Microsoft FoxPro for Windows 2.5b
- Microsoft FoxPro for Windows 2.6
- Microsoft FoxPro for MS-DOS 2.0
- Microsoft FoxPro for MS-DOS 2.5
- Microsoft FoxPro for MS-DOS 2.5a
- Microsoft FoxPro for MS-DOS 2.5b
- Microsoft FoxPro for MS-DOS 2.6
This article was previously published under Q118554 SYMPTOMS
The error message below will be generated when you are using macro
substitution for the table name in the <alias>.<select_item> clause in
a SELECT-SQL statement:
SQL column <macro variable + table field> not found
RESOLUTION
To work around this behavior, insert an extra period (".") between each of
the macro-substituted tables and the table field names. For example:
SELECT &table1..cno, &table2..cno FROM &table1, &table2;
WHERE &table1..cno=&table2..cno INTO CURSOR QUERY
The extra period is required as a terminator for the macro substitution.
Modification Type: | Major | Last Reviewed: | 12/1/2003 |
---|
Keywords: | kberrmsg KB118554 |
---|
|