Re: How to FindNearest

On Tue, Oct 03, 2006 at 14:43:40 +0300,
Alexander Ilyin <a_ilyin(at)ukr(dot)net> wrote:
>
> Thank you for your great idea. But how it can be used for positioning the cursor in the already existed ResultSet? Using your idea I can found the closest to targetvalue row but not its position in my ResultSet.

You wouldn't be able to use it to position a cursor. But if you aren't
retrieving a lot of records at once, this may still be a workable strategy
for you.

> Anyway thank you for your idea it is very useful by itself. Also I can solve my problem using your idea and emulating the movement in my existed ResultSet. Even better - no need to store the large RS between cursor movements. Just each time I need to fetch the all visible rows.

That sounds pretty reasonable.