>I'd love to know what happened ... the simplest GROUP BY clause fails with INVALID OR MISSING GROUP BY CLAUSE
>
>This fails:
>
>SELECT * FROM myfile INTO CURSOR mycursor GROUP BY 1
>
>OR EVEN
>
>SELECT * FROM myfile INTO CURSOR mycursor GROUP BY iapptid
>
>?????

John,
First off, don't do that!

What are you trying to accomplish in the SQL above? If you have the following table:

Field1   Field2    Field3
John     Smith     USA
John     Jones     Mexico
John     Wilson    Germany

In previous versions to 8, VFP would return the information in the record physically located last in the table. So you would get the following result:

John     Wilson    Germany

Is that what you want?

Other DBMS don't allow this. You must specify all fields that are not part of an aggregate function.

Having said all that, you can override VFP 8 and make it behave like VFP using the SET ENGINEBEHAVIOR command of the new SYS(3099,70) (7.0 compatibility). See the Help for more information.

HTH.