>hi to all,
>
>In a SELECT SQL written in Oracle you can insert in the where expression a clause to stop the query after to have found N records, and you can do this with :
>

Maybe the FetchSize property of the CURSORSETPROP() command is what you are looking for.
something like CURSORSETPROP("FetchSize", 500) for your case.

For this you have to work with views.
For more details on this look in the VFP Help file.
Hopefully it can put you on the right track.