>>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only