Hi Jason!

Thank you.
This is perfectly what I was looking for!

Regards, Boris

Jason Wharton schrieb:

> You may have shared them already but what is it your are trying to
> accomplish with your user interface. What controls are you using?
>
> One thing my users have grown very accustomed to is the search mode features
> of the native IBO controls and components. This allows all of your data
> entry controls to go into search mode in which your users can type in a rich
> array of simple search criteria items. Then, they can post the search and
> the matching records are brought back to the server. This is the most
> flexible and ideal way to interact with a client/server database. You don't
> have to use the flat-file emulation layer that the Locate() method relies
> upon. You just refine your query and pull only the records needed. But, what
> I was trying to avoid suggesting you scrap your current user interface
> design. If this an option, there are far better mechanisms in IBO that a
> fancy Locate() implementation.
>
> Regards,
> Jason Wharton
> CPS - Mesa AZ
> http://www.ibobjects.com
>
> ----- Original Message -----
> From: "Boris Schlüszler" <boris@...>
> Newsgroups: egroups.ibobjects
> To: <IBObjects@yahoogroups.com>
> Sent: Thursday, December 06, 2001 2:00 AM
> Subject: Re: [IBO] findkey/seek on TIB_Query
>
> > 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/
> >
> >
> >
> ___________________________________________________________________________
> > 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/