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

You're welcome