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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only