Thank you thank you thank you. How did you find out about this set enginebehavior? Has this been talked about before (I just joined UT)? I freaked out because our system uses group by in several places to get unique values ie:
We have an appointdetail table containing IAPPTID which relates to the IID field in appointheader. One place we simply wanted a listing of all unique IAPPTID records and the DDATE field of each (same date across all same IAPPTID records).
SELECT appointdetail.* FROM appointdetail JOIN ON appointheader.iid = appointdetail.iapptid INTO CURSOR mycursor GROUP BY iapptid
This worked fine if fox 7 and as you know dies in fox 8 with GROUP BY invalid or missing.
I can't get any group by to work if it includes fields that are not in the group by clause.
Again, thanks.
John
Précédent
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