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/
>
>
>