Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sqlserver CASE WHEN.. THEN ... END doesn't work with vfp 9
Message
From
15/01/2011 05:01:24
Jean Martin
Datamanager Ci
Cote d'Ivoire
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Sqlserver CASE WHEN.. THEN ... END doesn't work with vfp 9
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
MS SQL Server
Miscellaneous
Thread ID:
01496269
Message ID:
01496269
Views:
112
hi, i'm rewriting local views to remote sqlserver 2000 views. but i have a problem.

IIF() statement must be replace by CASE WHEN condition1 THEN x ELSE y END.
this CASE statement doesn't work and that causes error. how to write it ?
Next
Reply
Map
View

Click here to load this message in the networking platform