PRB: Query Designer Reports Syntax Error but Still Succeeds

ID: Q166883

The information in this article applies to:

SYMPTOMS

The Query Designer reports an error after valid SQL text is entered into the SQL text pane and executed.


CAUSE

When text entered into the SQL pane is executed, the Query Designer first processes the text and then sends it to the database for execution. An error dialog box may appear if either of these two steps is unsuccessful.

After you enter text into the SQL pane, the query designer first attempts to understand the text and graphically map its elements into the Diagram and Grid panes. When the statement cannot be understood, a notification dialog box containing a brief description of the error appears. The Diagram and Grid panes turn gray, indicating the failure. If the syntax is recognized, the Diagram and Grid panes update to show the query graphically.

In the second step, the text is sent to the database for processing. If the database does not recognize the SQL syntax, it returns an error that is displayed by the query designer. If the SQL syntax is recognized, the result set or success/fair report is displayed.


RESOLUTION

To execute statements without the first verification step, simply use the right-click context menu to hide the Diagram and Grid panes. With these panes turned off, the first verification step is bypassed and the raw text is sent directly to the database for execution.


STATUS

This behavior is by design.


MORE INFORMATION

Steps to Reproduce Behavior

  1. Start the Query Designer.


  2. In the SQL Pane, enter the following text:
    CREATE TABLE test1 (field1 char (20))


  3. Click RUN (!) on the toolbar.


Result: Since the query designer cannot display this type of SQL statement graphically, a notification dialog box indicating this appears. After the notification dialog box is cleared, a success report indicating that the table was created on the server 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/

Additional query words: 


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

Last Reviewed: April 2, 1999