PRB: Query Designer Does Not Add Parenthesis to CriteriaID: Q166884
|
If you type the following example in the Grid pane of the Query Designer:
Column CriteriaThe following error message appears:
EmpId IN 123, 456
Missing subquery or the operator you entered requires parenthesis.
Invalid SQL syntax has been entered into the criteria cell. In SQL2, the comparison operation IN requires parenthesis around its contents:
IN (table-expression) or IN (value-list)
Add parenthesis around the table-expression or value-list before tabbing out of the field.
This behavior is by design.
In 123, 456
For 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
Version : WINDOWS:1.0
Platform : WINDOWS
Issue type : kbprb
Last Reviewed: May 10, 1999