The idea is to set view to return more than 100 records and then MaxRecords will limit this number to 100.

>This question has me interested too. Lets say you have a paramaterized remote view, and becuase of the paramater, the view returns just one record. Is there an easy way to snag the 100 records on either side of one record returned? Or is their an easy way to make the paramter do it somehow?
>
>
>>>I list this in Client/Server because the solution needs to deal with either a VFP database or some other backend (Oracle, SQL-Server). I need to be able to draw, let's say 200 records, 100 before and 100 after some specific record. How the user gets to the specific record will be handled typically by incremental searching. The desire is to only bring a limited number of records across the network and to display that limited record set. Of course this must be highly dynamic as the user changes positions in the entire table/view.
>>>
>>>Any good ideas?
>>>
>>>Thanks,
>>>Steve
>>
>>If you CURSORSETPROP() MaxRecords property =100 for remote view than it will draw 100 records with proper ORDER. I guess it could be done even better in stored procedure, e.g. in SQL Server you can set @@ROWCOUNT=100 and UNION two SELECTs