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

Try this :

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

Notice there is a space after credit ( or put one before FROM )

Since you allow nulls for sens and montant that may be causing a problem as well if you have any null values in either one. If you try the code above and still errors you should try testing for nulls as well. ( better to not allow them in those fields if you really don't need them )

I see you allow nulls in all your fields - do you really not have a primary key field ?