PRB: View Designer Rewrites WHERE ClauseLast reviewed: July 14, 1997Article ID: Q164369 |
The information in this article applies to:
SYMPTOMSWhen a local SQL view is created from a CREATE SQL VIEW command with SELECT - SQL statement, the parenthetical WHERE clause is rewritten in View Designer.
CAUSEAccording to the SQL lexicon, there is no parentheses support in SQL.
RESOLUTIONIn View Designer, the parenthetical HAVING clause is parsed correctly. Since HAVING sets conditions for the GROUP BY clause similarly to the way that WHERE sets conditions for the SELECT clause; and HAVING without GROUP BY has the same filtering effect as WHERE. The workaround for this problem is to replace WHERE clause with HAVING, whenever it is applicable.
STATUSThis behavior is by design. The view designer was not built to handle parenthetical WHERE clauses.
MORE INFORMATION
Steps to Reproduce Behavior
|
Keywords : FxprgSql vfoxwin
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |