>>>>That was a tip by Tamar Granor on the last NY User Group meeting.
>>>
>>>Did you test it?
>>
>>Nope and even can not - since I don't have VFP9. But if I recall correctly we did run tests for this technique. The other question is to get original recno() back - that is also solved with derived tables but in the different order.
>
>It gives 'syntax error' in VFP9.
Can you put your exact sample here please?
If it's not broken, fix it until it is.
My Blog