PRB: Incomplete Parameter Delimiters Causes Confusing Error

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

SYMPTOMS

The Query Definitions Differ dialog box displays the following error when the user fails to fully delimit parameters in their SQL test: 

   Invalid text or symbol Error in WHERE clause: 'example = test' not
   recognized

CAUSE

The Query Designer cannot always guess what your intentions are when you start a parameter without terminating it in your SQL text.

RESOLUTION

Go back into the SQL text and correctly delimit the parameter value for the query.

STATUS

This behavior is by design.

MORE INFORMATION

Steps to Reproduce Behavior

Activate the property page, go to the Parameters page and use % for the prefix and suffix characters for parameters. Type into the SQL pane, the following query: 

   SELECT stor_id FROM stores WHERE %city = CA
Click into the Results pane. The Query Designer displays the Query Definitions Differ dialog box and click OK. The Query Designer shows the resulting statement in the SQL pane: 

   SELECT stor_id FROM stores WHERE %city = CA%
You can fix the query by modifying the text to read: 

   SELECT stor_id FROM stores WHERE city = %CA%

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 kberrmsg
Technology        : kbInetDev
Version           : WINDOWS: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.