Subject Re: [IBO] Locate Vs LookupKeyForFields Vs ??
Author Jason Wharton
You are not imagining things.

Locate maps into LookupForKeyFields if it can so it is no surprise that you
see equivalent results.

In order to get the local record fetching feature going you need to use the
horizontal dataset refinement capabilities.

Please search the archives.

HINT: It has to do with how you setup the ordering of datasets in the
OrderingLinks property.

Jason Wharton
CPS - Mesa AZ

-- We may not have it all together --
-- But together we have it all --

----- Original Message -----
From: "Alan McDonald" <alan@...>
To: <>
Sent: Sunday, January 12, 2003 5:35 AM
Subject: [IBO] Locate Vs LookupKeyForFields Vs ??

> I still can't get to the bottom of what is the best (most
> method of returning a recordset to it's last known position...
> When I exit my app I save the keyfield value of a dataset to registry. I
> want to return to this record as quickly as possible and position the grid
> cursor on this record before I show the grid.
> I have used the KetFields.Values[] / LookupKeyForFields method and also
> Locate method. they take exactly the same amount of time to get to the
> record in question.
> I understood (perhaps mistakenly) that IBO could wave it's wand on this
> not fetch all the records to achieve this, but it appears that all records
> are indeed fetched. (e.g. the last record in a large dataset takes a lot
> longer than the first record).
> I seem to remember reading somewhere on the docs that IBO could be made to
> fetch only records surrounding the keyvalue in question (i.e. enough to
> buffers) .. Am I imagining things?
> Alan
> IB Objects - direct, complete, custom connectivity to Firebird or
> without the need for BDE, ODBC or any other layer.
> - your IBO community resource for Tech Info
> keyword-searchable FAQ, community code contributions and more !
> Your use of Yahoo! Groups is subject to