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