PRB: Query Designer Does Not Add Parenthesis to Criteria

 Last reviewed: December 11, 1997
Article ID: Q166884
The information in this article applies to:
  • Microsoft Visual Database Tools, version 1.0

SYMPTOMS

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

   Column   Criteria
   EmpId    IN 123, 456
then 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

  • 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          : kbDtQDesigner
Version           : 1.0
Platform          : WINDOWS
Issue type        : kbprb

    • ================================================================================

    THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

    Last reviewed: December 11, 1997
    © 1998 Microsoft Corporation. All rights reserved. Terms of Use.