Hi!
I'm looking for some explanation on the radical change
in the group by clause

a quote from VFP 8.0 help
"The GROUP BY clause must list every field in the SELECT list except for fields contained in an aggregate function, such as the COUNT( ) function. "

I found it while converting a running project from 7.0 to 8.0 a great amount of my reports don't work (all of them based on queries)

well: I know I could issue a SET ENGINEBEHAVIOR 70 but then I might miss other new stuff related to 8.0, don't I?

actually I would like to know what is the reason for this change that is going to make me write GROUP BY statemnts for 20, 30 and sometimes more fields.

am I missing something?

thanks in advance,

Nir.