PRB: View Designer Errors if Query Cannot Display Graphically

ID: Q201868

The information in this article applies to:
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.

Additional query words: prodsql 


Keywords          : kbSQLServ700 
Version           : winnt:7.0
Platform          : winnt 
Issue type        : kbprb

Last Reviewed: June 8, 1999