>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