Hi Jason!

Yes, it's much quicker now.
But it's still too slow (lookup on a table with maybe 250.000 records).
I will try something else.

Regards, Boris

Jason Wharton schrieb:

> 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
> http://www.ibobjects.com
>
> ----- Original Message -----
> From: "Boris Schlüszler" <boris@...>
> Newsgroups: egroups.ibobjects
> To: <IBObjects@yahoogroups.com>
> 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
> 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/