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 ).