Alan,

> I was under the impression that Locate still worked client side after
> fetching all records needed. I also thought that the LookUpKeyForFields
> would start the fetch at that key value and fill the buffers from that
> point, not fetch all records until that key value was struck.

may I suggest that you have a look at the IBO Online FAQ?
http://faq.ibobjects.com/scripts/ibofaq.dll

- Search for "Horizontal dataset refinement" in the SUB-CATEGORIES
listbox.

Clear previous search ...

- Search for "Locate() Method" in the KEYWORDS listbox.

Sorry to be not more specific here. Probably others can jump in here ...

HTH,
Thomas

>
> Alan
>
> -----Original Message-----
> From: Thomas Steinmaurer [mailto:ts@...]
> Sent: Monday, 30 December 2002 12:33 AM
> To: IBObjects@yahoogroups.com
> Subject: RE: [IBO] Fetching Query Results
>
>
> > Actually...
> > I have an AfterOpen event which puts my users back where they were when
> the
> > app was last exited... I assumed that I could move to the record in
> question
> > without much fuss, but this method of getting there, to fill the grid
> > buffers, seems to fetch all the records if the one I want is near the
> bottom
> > of the dataset... thus the dialog in question and the delay I wasn't
> > expecting.
> >
> > IB_QBlocks.KeyFields.Values['BLOCKIND'] := irLastBlock;
> > IB_QBlocks.LookupKeyForFields;
> >
> > Is there a faster way to seek / locate this record and fill the buffers?
>
> Don't know exactly how the internals for your above statements
> work. Have you tried TIB_Query.Locate with HDR activated?
>
> Thomas.
>
>
>
> ___________________________________________________________________________
> 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/
>
>
>