General information
Title:
Difference SQL and VFP
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
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