Hi All,
The select statement below was working fine until I recomplied my application with vfp8.
After the upgrade the "Group by clause" error message appears.
I've seen the messages/warnings about the group by clause but am not sure why this causes the error since no 'group by' is stated.
I added the 'set enginebehavior 70' and the error goes away.
How would you re-write this so it would work without the 'set enginebehavior 70 ' ?
select ;
rps, ;
sum(share) as shares, ;
sum(cmp) as comps, ;
sum(iif(cmp>0,iif(sale_pool="Y",cmp,000.00),000.00)) as salepool ;
from ;
SYN_MEM ;
where ;
stallion = “ARTURO” ;
and ;
inact = " " ;
into cursor sys(2015)
Thanks,
Jim Harvey