Hi Stephen

>Is there a reason why
>
>

>SELECT * FROM tblData GROUP BY field1
>

>
>fail in VFP8 but work in VFP7? Did the syntax changed in VFP8?

Yes. This is documented in the help file. VFP now, by default, requires that fields not specifically named in an aggregate function (SUM, COUNT etc) must be explicitly included in the GROUP BY. This is to make VFP SQL more closely conformant with the ANSI Standards and other databases.

Use "SET ENGINEBEHAVIOR 70" to run VFP 7.0 SQL code under VFP 8.0