Subject | Re: [IBO] Dataset Lookup |
---|---|
Author | IB Objects |
Post date | 2003-07-31T05:48:18Z |
> I remember ages ago Jason planned to implement somethingYes, this has been complete for some time now.
> (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?
> The reason I ask this is because I have 3 different adresses connectedhave
> 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
> that query be populated as needed. This would preven duplicates fetchesI'm not really clear on what your scenario is but it sounds like you could
> (As often 2 of the adresses may be the same).
use a single query.
> Also, is there some better way to jump to a certain record of which the PKThe Locate() method optimizes where it can so chances are if you are
> value is know then to use the Locate method?
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