PRB: Query Designer Does Not Add Parenthesis to Criteria

ID: Q166884

The information in this article applies to:

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/support/vinterdev/


Keywords          : kbVisDBTools kbGrpASP kbDtQDesigner 
Version           : WINDOWS:1.0
Platform          : WINDOWS 
Issue type        : kbprb

Last Reviewed: May 10, 1999