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