>>>>It was exactly your sample.
>>>
>>>Not sure why it didn't work - AFAIK it should. Ok, if I can find VFP9 somewhere I'll test.
>>>
>>>Thanks.
>>Tested
www.microcomplex.com/temp/Test.jpg ;o(
>
>I am sorry, I cannot use links here. What did you get?
but as SB said this works
select MyField1, myField2, recno() as myRec;
from (select myField1, myField2 from myTable) DeravedTableName;
INTO CURSOR crsTest
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst