The following statement will retrieve the correct record in VFP
SELECT * FROM HISTORY WHERE RecNo() = 1 INTO CURSOR ItemList0
But the following statement:
SELECT * FROM HISTORY WHERE RecNo("History") = 1 INTO CURSOR ItemList0
will retrieve all records from History in VFP5 but 0 records in VFP6
Anybody knows why? Just a bug?
-----------------------------------------------------------------
Paul Lee ........... Abri Technologies .........
http://abri.com/ 'Recover' - top rated FoxPro/dBase file repair utility.