Paul,

SQL takes the liberty of opening tables in other work areas and under other aliases to do it's job. Any time you use RECNO("MyTable") you leave yourself open to getting the wrong results.

Are you just after the first record (or was that an example)? There are work-arounds with COPY TO, etc. but they have more steps.


>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?