PRB: Data Designer Does Not Support CASE Statements in Views

ID: Q194014

The information in this article applies to:

• Microsoft SQL Server version 6.5
• Microsoft Visual InterDev, version 6.0

SYMPTOMS

When saving a SQL Server view in the Visual InterDev Data Designer, the following error occurs:

   The following errors were encountered while parsing the contents of the
   SQL pane:

      CASE not supported

CAUSE

CASE statements are not supported in the Data Designer.

STATUS

This behavior is by design.

MORE INFORMATION

Although the error message appears, all changes made to the view are in fact saved. You can continue to edit the views in the Data Designer or use SQL Enterprise Manager.

Steps to Reproduce Behavior

1. Open a Web project with a data connection. 2. Open a SQL Server view with a CASE statement in design view. 3. Make a change to the view. 4. Save the view.

Additional query words: SEM

Version           : WINDOWS:6.0; WINNT:6.5
Platform          : WINDOWS winnt
Issue type        : kbprb

Last Reviewed: October 12, 1998