Sqlserver CASE WHEN.. THEN ... END doesn't work with vfp 9

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Sqlserver CASE WHEN.. THEN ... END doesn't work with vfp 9

Message

15/01/2011 05:01:24

Jean Martin
Datamanager Ci
Côte d'Ivoire

Tous

Information générale

Forum:

Visual FoxPro

Catégorie:

Base de données, Tables, Vues, Index et syntaxe SQL

Titre:

Sqlserver CASE WHEN.. THEN ... END doesn't work with vfp 9

Versions des environnements

Visual FoxPro:

VFP 9 SP1

OS:

Windows XP SP2

Database:

MS SQL Server

Divers

Thread ID:

01496269

Message ID:

01496269

Vues:

113

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 ?

Répondre

Fil

Voir

Click here to load this message in the networking platform