PRB: Syntax Error with the Query WizardLast reviewed: January 8, 1996Article ID: Q141915 |
The information in this article applies to:
SYMPTOMSWhen you use the Query Wizard or the Local View Wizard to build a query or a local view, the wizard generates a syntax error. The only selection criteria are the fields you use. This only happens with a specific table named group.
CAUSEThe table name is not valid. The Query Wizard generates a SELECT-SQL statement. In this case, the SELECT statement looks like this:
SELECT GROUP.* from GROUPIt generates a "Syntax error" because the name group is invalid.
WORKAROUNDRename the table.
STATUSThis behavior is by design.
MORE INFORMATIONOther table names that generate an error are Order and From.
Steps to Reproduce Behavior
|
Additional reference words: 3.00 3.00b VFoxWin
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |