PRB: View Designer Errors if Query Cannot Display Graphically (201868)

The information in this article applies to:

Microsoft SQL Server 7.0

This article was previously published under Q201868

BUG #: 49469 (SQLBUG_70)

SYMPTOMS

The SQL Enterprise Manager View Designer gives errors if a query cannot be displayed graphically.

For example, when you create a view with the following query:

   SELECT cast(au_id AS varchar(5))
   FROM authors

You receive the following error when you execute the query:

AS is not supported

If you click Yes, the view is created and the results are returned in the Results pane, but there is no graphical display in the Diagram or Grid panes.

CAUSE

Enterprise Manager shows this behavior when you enter a query in the SQL pane that cannot be displayed graphically. You have the option of undoing the changes or allowing the changes but not being able to graphically edit the query in the future.

WORKAROUND

Hide the Grid and Diagram panes and the error does not appear.

Modification Type:	Major	Last Reviewed:	10/27/2000
Keywords:	kbprb KB201868