PRB: Query Designer Does Not Add Parenthesis to Criteria (166884)


The information in this article applies to:

  • Microsoft Visual Database Tools
This article was previously published under Q166884

SYMPTOMS

If you type the following example in the Grid pane of the Query Designer:

Column Criteria
EmpId IN 123, 456

The following error message appears:
Missing subquery or the operator you entered requires parenthesis.

CAUSE

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)

RESOLUTION

Add parenthesis around the table-expression or value-list before tabbing out of the field.

STATUS

This behavior is by design.

MORE INFORMATION

Steps to Reproduce Behavior

  1. Open or create a new Visual InterDev project.
  2. Add a dataconnection to your project.
  3. Double-click one of your tables to invoke the Query Designer.
  4. On the Query toolbar, click the first four icons to display the four panes to the Query Designer.
  5. In the Grid Pane, select a field in the "Column" column, and type the following in the Criteria field:

    In 123, 456

  6. Tab out of the Criteria field. The error message appears.

REFERENCES

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/search/default.aspx?qu=vinterdev

Modification Type:MajorLast Reviewed:5/2/2006
Keywords:kbDatabase kberrmsg kbprb KB166884
©2004 Microsoft Corporation. All rights reserved.