>>This code give a syntax error:

CREATE CURSOR curtest (test1 I, test2 I)
>>*-- Add rows here
>>select test1, test2, recno() from (select test1, test2 from curtest)

>>It gives 'syntax error' in VFP9.
>>>
>>>Can you put your exact sample here please?
>
>You're missins a name for derived table which is required
>

>select test1, test2, recno() from (select test1, test2 from curtest) DeravedTableName
>

Now it works! Thank you.