Subject Re: [IBO] findkey/seek on TIB_Query
Author Jason Wharton
With the TIB_Query component it requires a little setup to accomplish this.
With TIBOTable it is automatically setup for you.

In short, it has to do with the OrderingLinks property. There should be a
FAQ on that or it should be in the help file. Look for mention of the POS
attribute of that property.

Jason Wharton
CPS - Mesa AZ

----- Original Message -----
From: "Boris Schlüszler" <boris@...>
Newsgroups: egroups.ibobjects
To: <>
Sent: Tuesday, December 04, 2001 7:29 AM
Subject: [IBO] findkey/seek on TIB_Query

> Hello!
> Is there a way to accomplish a Seek/FindKey on a TIB_Query?
> I have a large dataset which is displayed in a TIB_Grid ("select * from
> pipapo").
> In this dataset I'd like to make one particular row active. Maybe the
> last one.
> The column is indexed. I have great respone times with "select * from
> pipapo where IDXColumn=:search'").
> Is it possible, to Locate in the dataset, without fetching all the rows?
> I could imagine something like this:
> 1.) The buffer is load with as many values as needed for display. (As
> indeed is, as long as AutoFetchAll is set to False): "select * from
> table"
> 2.) Search value is given. On Interbase a Cursor with the search values
> is declared. "select * from table where Search=:search"
> 3.) Fetch (and add) as many rows from the Cursor into the current
> dataset's buffer
> as needed for display. While doing this, suppress duplicates by checking
> KeyLinks.
> Then I could overcome longer times of loading column values for
> scannning all the rows
> into the buffer.
> Maybe this is implemented and I do not understand it?
> Regards, Boris
> 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