Better than setting enginebehavior though, is to try to change your sql call to use the more 'acceptable' syntax of making sure all your non aggregate fields from the select clause are in the group by clause. The reason it was changed in VFP8 was because the results returned using the old syntax can be misleading.
Alan
>Denis, thank you...that works. I guess I need to go back to school.
>
>Joel
>
>>Hi,
>>try
>>SET ENGINEBEHAVIOR 70
>>
>>>I've used the GROUP BY clause thousands of times. Now, all of a sudden in VFP 8.0, I'm getting an error message (Group by clause is missing or invalid) on a simple SQL statement:
>>>
>>>SELECT item, vendno, mfgbc ;
>>> FROM icsupl ;
>>> WHERE item = "9999-99-99" ;
>>> GROUP BY 2 ;
>>> INTO CURSOR xxxxx
>>>
>>>...will someone tell me what's going on.
>>>
>>>Joel
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