The information in this article applies to:
SYMPTOMSIf you type the following example in the Grid pane of the Query Designer: Column CriteriaThe following error message appears:
CAUSEInvalid SQL syntax has been entered into the criteria cell. In SQL2, the comparison operation IN requires parenthesis around its contents:
RESOLUTIONAdd parenthesis around the table-expression or value-list before tabbing out of the field. STATUSThis behavior is by design. MORE INFORMATIONSteps to Reproduce Behavior
REFERENCESFor the latest Knowledge Base articles and other support information on Visual InterDev and Active Server Pages, see the following page on the Microsoft Technical Support site: http://support.microsoft.com/support/vinterdev/
Keywords : kbVisDBTools kbGrpASP kbDtQDesigner |
Last Reviewed: November 8, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |