>>>>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?
CREATE CURSOR myTable (MyField1 C(10), myField2 C(20))
INSERT INTO myTable VALUES ([1],[1111111])
INSERT INTO myTable VALUES ([2],[2222222])
INSERT INTO myTable VALUES ([3],[3333333])
INSERT INTO myTable VALUES ([4],[4444444])
select MyField1, myField2, recno() as myRec;
from (select myField1, myField2 from myTable);
INTO CURSOR crsTest
BROWSE NORMAL
Syntax error on
from (select myField1, myField2 from myTable);
_______________________________________________________________
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