He may if aTABLE is a memo field.
>Sergey, too quick on the draw. Unless I'm missing something, his select only selects 1 field from the table. He shouldn't be getting the error.
>
>Alan
>
>>It's documented in VFP8 help under
Behavior Changes Since Visual FoxPro 7.0 and
INFO: SQL SELECT Behavior Changes in Visual FoxPro 8.0 mskb #
813361.
>>
>>
>>>Hello,
>>>
>>>This look serious.
>>>
>>>I have SELECT aTABLE FROM MYTABLE GROUP BY 1
>>>
>>>and I get Group by clause is missing or invalid.
>>>
>>>Any help will be appreciated.
>>>
>>>VFP8 on XPsp1
>>>
>>>Thanks,
>>>Pablo
--sb--