PRB: "SQL Column Not Found" with Macro Substitution in SELECT

Article ID: 118554

Article Last Modified on 12/1/2003

• Microsoft Visual FoxPro 3.0 Standard Edition
• Microsoft FoxPro 2.5b for Macintosh
• Microsoft Visual FoxPro 2.5c for Macintosh
• Microsoft FoxPro 2.5b
• Microsoft FoxPro 2.5a
• Microsoft FoxPro 2.5b
• Microsoft FoxPro 2.6 Standard Edition
• Microsoft FoxPro 2.0
• Microsoft FoxPro 2.5b for MS-DOS
• Microsoft FoxPro 2.5a
• Microsoft FoxPro 2.5b for MS-DOS
• Microsoft FoxPro 2.6 for MS-DOS

   SQL column <macro variable + table field> not found
				

   table1='customer'
   table2='invoices'
   SELECT customer.cno, invoices.cno FROM &table1, &table2;
      WHERE customer.cno=invoices.cno INTO CURSOR QUERY
				

   SELECT &table1.cno, &table2.cno FROM &table1, &table2;
      WHERE &table1.cno=&table2.cno INTO CURSOR QUERY
				

   SELECT &table1..cno, &table2..cno FROM &table1, &table2;
      WHERE &table1..cno=&table2..cno INTO CURSOR QUERY
				

Additional query words: VFoxWin FoxMac FoxDos FoxWin

Keywords: kberrmsg KB118554