>>>I am converting a program from VFP to SQL with ado.
>>>
>>>I seems that the sql statements are not compatible.
>>>The SUM with an IIF statement does not give the correct result
>>>
>>>Example
>>>
>>>select *, sum(uurfact) as fact, SUM(IIF(ureisk='Ja ',1,0)) as reisk from uren where umcode= '20002 ' group by umcode
>>>
>>>Can someone help me.
>>>
>>>Kind regards
>>>
>>>
>>>Jan Dorresteijn
>>
>>IIF is a VFP command and not recognized by SQL Server.
>
>OK but is there an other solution
>
>Kind regards,
>
>Jan

Hi Jan,

There may be two solutions. One lengthy, and the other a little more tricky.

1) You get your core data into a VFP cursor (without the grouping) and then run your SQL, so it then becomes a native VFP call, or,

2) You write a stored procedure in SQL Server and make a call to run that stored procedure in the server.

Rgds,

Sanjay