>Is there a reason why
>
>
>SELECT * FROM tblData GROUP BY field1
>
>
>fail in VFP8 but work in VFP7? Did the syntax changed in VFP8?
Stephen,
As others have posted, there is a "work around" for this behavior change. However, I have to ask, what kind of results are you looking for when you execute a query like this? Do you expect to get any meaningful data? The only valid values will be in Field1. All other data is suspect and should be treated as invalid.
Regards.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao