--- In IBObjects@egroups.com, "Jason Wharton" <jwharton@i...> wrote:

> Yes, use the TIBOTable component.
>
> Jason Wharton
> CPS - Mesa AZ
> http://www.ibobjects.com
>
>
> ----- Original Message -----
> From: "luis forra" <luis.forra@u...>
> To: <IBObjects@egroups.com>
> Sent: Wednesday, January 24, 2001 11:57 AM
> Subject: [IBO] IBO TTable replacement ?
>
>
> > Does IBO have a TTable replacement with suport for
> > FindKey,
> > FindNearest (using two cursors "SELECT PK,... WHERE PK < :LK

ORDER BY

> > PK DESC" and "SELECT PK,... WHERE PK >= :LK ORDER BY PK") ,
> > GoBottom ( using "SELECT PK,... ORDER BY PK DESC") ?
> >
> > Best regards
> >
> > Luis Forra

The behaviour of TIBOTable is diferent. If I have
25000 rows in a Table and I do a FindNearest with TIOBTable to the
last row I get 250000 fetch's with TTable I get very few fetch's.

It seem also that that this code is faster:

IBOTable.FindNearest(['LAST_PK']);
IBOTable.Close;
IBOTable.Open;
IBOTable.FindNearest(['LAST_PK']);

than :

IBOTable.FindNearest(['LAST_PK']);
IBOTable.FindNearest(['LAST_PK']);

Best regards

Luis Forra
---