Hi all,
I am going to play the redneck programmer this time. I am trying to convert my sql strings from vfp 6 to vfp 8 with group by clauses in ‘um. But reading over the documents I have found, they talk about “aggregate functions”. I am taking that to mean that the field is in a user-defined function in the select area – like upper(file.fieldname) OR right(alltrim(file.fieldname), 3). If I am wrong, please tell me.

The documentation states that all fields in the select area need to be in the group by area, but how can that be if the field is in that “aggregate function”?

So, how do I know what fields need to be in the group by area? I have a program (QueryMaker) that can change those fields on the fly, and I need to know which fields to be sure are in the area(clause?)

Hope this makes sense.
Thanks for any info.
Beth