In a client server application you generally don't allow the user to navigate an entire table using first, last, next, previous buttons. A better idea would be to have the user enter some search criteria to narrow the scope and then get the records the user asked for. Once you have a subset of records at the front end you can allow the user to navigate those. There's not really a good way to simulate this kind of navigation in c/s because in c/s there's not really a concept of first, last, or next record.

>Hi to all,
>My tables are very large so I cannot use a view to load the entire table, I want to load only a record at time.
>If I cannot use the SKIP and GO xx command, how can I implement a navigation toolbar like vcr (top/previous/next/bottom) in a client/server application using SQL server or Oracle ?