>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 ?
>
>Thanks in advance for any suggestion
You will probably have to use retrievals that rely on a key id or a special field that has a sort order code in it. To be most efficient, you could retrieve a batch of rows each time for the user to navigate through. When the user navigates to the last row of the batch, you would have to re-issue the SQL command modified to retrieve the next batch.
I know in the SQL options you can set the number of rows to retrieve at a time. You could set this parameter to retrieve 10 rows (or whatever number) at a time.
Mark McCasland
Midlothian, TX USA