Re: How to FindNearest

On Tue, Oct 03, 2006 at 14:43:40 +0300, Alexander Ilyin <a_ilyin@ukr.net> wrote:
> 
> Thank you for your great idea. But how it can be used for positioning the cursor in the already existed ResultSet?
Usingyour 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
themovement in my existed ResultSet. Even better - no need to store the large RS between cursor movements. Just each
timeI need to fetch the all visible rows.
 

That sounds pretty reasonable.