Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
How Do You All Handle Group By Command
Versions des environnements
Network:
Windows 2000 Server
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement