Subject Re: [IBO] Dataset Lookup
Author IB Objects
> I remember ages ago Jason planned to implement something
> (I think he called it horizontal dataset refinement), where if you
> were searching for a particular record it would open a new
> cursor and start fetching from there.
>
> Has this ever been put in?

Yes, this has been complete for some time now.

> The reason I ask this is because I have 3 different adresses connected
> to one table (linked over their pk)
> I manualy display them (non data-aware controls).
> I was wondering if it was possible to just use 1 query for all three and
have
> that query be populated as needed. This would preven duplicates fetches
> (As often 2 of the adresses may be the same).

I'm not really clear on what your scenario is but it sounds like you could
use a single query.

> Also, is there some better way to jump to a certain record of which the PK
> value is know then to use the Locate method?

The Locate() method optimizes where it can so chances are if you are
locating based on the primary key then it will be as fast as if you are
using a bookmark. If you want ease of use and to be sure to using the
fastest way just use bookmarks.

Jason Wharton
http://www.ibobjects.com