This approch doesnt work well for remote views. I would suggest that you rethink your design and let user to pick subset of the records based on some criteria before browsing them.
>I have a SQL table which contains 10 thousand records.
>It is not possible to fetch all records to navigate
>the records, such as using the toolbar:
> , because there are too many records,
>I use filter condition to create a remote SQL view:
>
>CREATE SQL VIEW item2 REMOTE CONNECTION connect1 ;
> AS SELECT top 10 * FROM item WHERE itemid >= ?_id ;
> ORDER BY itemid
>
>In this case, if I want to find a item, I need only
>to change the variable value of "_id" and then requery()
>the view in my application. But when I want to go
>or , I found I can't move to the right record pointer
>because I don't know the exactly value of "itemid",
>How can I navigate to the right records? Is there any
>other approach method to do with navigation toolbar?
>Thank for any help.
--sb--