Thanks Jason - the treasure hunt begins now.. :-)
Alan

-----Original Message-----
From: Jason Wharton [mailto:jwharton@...]
Sent: Tuesday, 14 January 2003 11:06 AM
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] Locate Vs LookupKeyForFields Vs ??


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.

Regards,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

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

----- Original Message -----
From: "Alan McDonald" <alan@...>
To: <IBObjects@yahoogroups.com>
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
efficient/fastest)
> 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
the
> 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
and
> 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
fill
> buffers) .. Am I imagining things?
>
> Alan
>
>
>
>
>
___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or
InterBase
> without the need for BDE, ODBC or any other layer.
>
___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info
papers,
> keyword-searchable FAQ, community code contributions and more !
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>



___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/