Versions des environnements
Kevin,
You are absolutely right...
Including Group by 1,2,3,4,5,6,7 (all my select fields) fix problem.
Thanks
Denis
>Denis,
>
>Staring in VFP8, (and this applies to the OLE provider as well), if you're using GROUP BY, you need to specify all columns in the GROUP BY that aren't aggregated. There is a setting for backwards compatability (SET ENGINEBEHAVIOR 70), though I don't know for a fact if you can specify that with the provider.
>
>Kevin
Précédent
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