I jumped from version 7 to 9 and remember reading about this in * but hadn't encountered it.

Thanks

>You've to include all non-aggregate fields into GROUP BY, enclose them into agregate functions MIN()/MAX() or remove them from the colimn list. It's documented in VFP9 help under SET ENGINEBEHAVIOR and in INFO: SQL SELECT Behavior Changes in Visual FoxPro 8.0 mskb #813361.
>
>
>>I am working with an application written in VFP 6 and keep running into problems with sql statements containing a Group By clause. I haven't found a common denominator. Any ideas?
>>
>>Here is an example cut from the code:
>>
>>

>>SELECT ;
>>     receipt.rec_date,receipt.receipt_no, paidinv.inv_no, ;
>>     receipt.type, receipt.card_no, receipt.exp_date, ;
>>     receipt.amount, receipt.country, receipt.exch_rate ;
>>	WHERE receipt.type $ "AMV" .and. receipt.rec_date = date() ;
>>        FROM receipt ;
>>	INNER JOIN paidinv ON receipt.receipt_no = paidinv.receipt_no ;
>>        Group By Receipt.receipt_no ; 	
>>        ORDER BY type ;
>>	INTO CURSOR dispcred
>>

>>
>>Thanks, Jeffrey