BUG: Alias with Same Name as Keyword in SELECT Causes Error

ID: Q118489

The information in this article applies to:

• Microsoft FoxPro for Windows, versions 2.5, 2.5a, 2.5b, 2.6
• Microsoft FoxPro for MS-DOS, versions 2.5, 2.5a, 2.5b, 2.6
• Microsoft FoxPro for Macintosh, version 2.5b

SYMPTOMS

If a table has the same name as any of the keywords in a SELECT-SQL command (for example, NOCONSOLE, PLAIN, UNION, or GROUP) and the table's alias is referenced as the first field in the list of fields in a SELECT-SQL command, a "Syntax Error" message will occur.

RESOLUTION

To avoid this problem, do one of the following:

• Do not use a keyword from the SELECT command as a table name.

  -or-

• Change the order of the fields in SELECT command so that the table's alias does not appear first in the list.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

Steps to Reproduce the Problem

Issue the following commands from the Command window:

   CREATE TABLE union (name C(10), age N(5))
   APPEND BLANK
   SELECT union.name FROM union

To avoid this error, issue the following command:

   SELECT age, union.name FROM union

This behavior is similar to that described in article Q112308, which describes a problem that occurs only in FoxPro version 2.0. In FoxPro version 2.0, the error occurs when you use a keyword anywhere in the SELECT command as a table name.

For more information about this problem, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q112308
   TITLE     : PRB: Reserved Words Invalid Table Names in FoxPro 2.0 SELECT