Microsoft KB Archive/194014

= PRB: Data Designer Does Not Support CASE Statements in Views =

Article ID: 194014

Article Last Modified on 5/29/2003

-

APPLIES TO


 * Microsoft Visual InterDev 6.0 Standard Edition
 * Microsoft SQL Server 6.5 Standard Edition
 * Microsoft SQL Server 7.0 Standard Edition
 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q194014



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.



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

Keywords: kberrmsg kbprb KB194014

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.