Hi Y'all,

I am just updating an app from VFP7 to 9 and knew I would have to deal with the change to the "GROUP BY" part of SQL. I have quite a few spots where I grouped by a single field or two before but now this needs updating. Some SELECT statements have a lot of fields so I don't relish adding all the new fields to the GROUP BY list.

How have some of you handled this?

a) just add them all and quit complaining :-)
b) write a function to dig out all of the table names in a string and macro expand it (with the original "group by" field first)

I realize that the new syntax is indeed better - I used to have to sometimes sort things in a particular order to get the desired result - because the old way would take the value of a non-grouped field from the *last* record read it seemed.

Thanks,

Albert Gostick