Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Sqlserver CASE WHEN.. THEN ... END doesn't work with vfp
Message
De
17/01/2011 03:59:54
 
 
À
16/01/2011 09:59:41
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
MS SQL Server
Divers
Thread ID:
01496269
Message ID:
01496345
Vues:
68
here is the sqlserver script that create the table DETMVT

CREATE TABLE [dbo].[DETMVT](
[NUMDET] [int] NULL,
[NUMMVT] [int] NULL,
[MVTDET] [int] NULL,
[NUMCPT] [int] NULL,
[RUBCPT] [int] NULL,
[MONTANT] [money] NULL,
[SENS] [int] NULL,
[GROUPE] [int] NULL,
[SOLDE] [money] NULL,
[SUPRIME] [bit] NULL
) ON [PRIMARY]

here is the VFP LOCAL VIEW i want convert into REMOTE VIEW

SELECT SUM(IIF(Detmvt.sens=1,Detmvt.montant,Detmvt.montant*0)) AS debit,;
SUM(IIF(Detmvt.sens=2,Detmvt.montant,Detmvt.montant*0)) AS credit;
FROM detmvt

REMOTE VIEW

SELECT SUM(CASE WHEN Detmvt.sens=1 THEN Detmvt.montant ELSE Detmvt.montant*0 END) AS debit,;
SUM(CASE WHEN Detmvt.sens=2 THEN Detmvt.montant ELSE Detmvt.montant*0 END ) AS credit;
FROM detmvt

error message sent by vfp after this code : FUNCTION NAME IS MISSING ).
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform