I am in process of upgrading to VFP 8, and having good luck except most of my queries that use a Group By clause are reporting errors. I remember reading some threads that talked about not using GROUP BY 1 so I have tried to be good and use only field names but I am still having problems. What has changed where the following query will work?

Select MainItem, ;
       RecordNum ;
  From curTemp ;
  Group By MainItem ;
  Order By RecordNum
  Into Cursor curMainItems