Microsoft KB Archive/166883

= PRB: Query Designer Reports Syntax Error But Still Succeeds =

Article ID: 166883

Article Last Modified on 5/2/2006

-

APPLIES TO


 * Microsoft Visual Database Tools

-



This article was previously published under Q166883



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.



Steps to Reproduce Behavior
 Start the Query Designer. In the SQL Pane, enter the following text:

CREATE TABLE test1 (field1 char (20))

 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.

