Re: How to scroll through query results?

From: Stephen Tenberg <STenberg_at_fcs-usa.com>
Date: Fri, 22 Jan 1999 21:16:27 GMT
Message-ID: <LU5q2.721$XG4.5037@nnrp2.ptd.net>

This is a fairly common problem, as most Oracle ODBC drivers have 'forward only' cursor support.

Where truly needed, it is fairly easy to simulate. (Some products, like Powersoft C++ will simulate it for you.)

When you retrieve the results, just keep the data (or just the rowid) in a linked list. Then you can easily reconstruct pages as they go backwards, from memory.

A little nasty to write, but no big deal.

Steve

Ilougino Rocha wrote in message <36A9414F.9AA23D90_at_haisystems.com>...
>I am writing a program which allows the user to browse large query
>results. How can I allow the user to page back if the cursor does not
>allow fetch previous. Thanks in advance Ilougino Rocha.
Received on Fri Jan 22 1999 - 15:16:27 CST