>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
Edward Pikman
Independent Consultant