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.

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/