Helen,

Don't be too quick to count TIBOTable out of the picture. It has some very
nice functionality built into it that the BDE stopped short of fully
completing. It sounds to me like TIBOTable is just the ticket for what this
person needs. It internally does all the stuff you would normally have to
do yourself manually with TIBOQuery. If you have the proper indexes defined
for ascending and descending order, TIBOTable can be a very nice component
to understand and use appropriately.

Jason Wharton
www.ibobjects.com

> -----Original Message-----
> From: Helen Borrie [mailto:helebor@...]
> Sent: Wednesday, January 19, 2005 1:25 AM
> To: IBObjects@yahoogroups.com
> Subject: Re: [IBO]
>
>
>
> At 09:49 AM 19/01/2005 +0200, you wrote:
>
> > Hi Group
> >
> > I have a TIBOTable connected to a 300,000 records
> table, when I activate
> >the table the first set of records is fetched into my grid,
> when I scroll
> >down more and more records are fetched, so far so good I
> have no problem at
> >all, but my aim is to do the same starting from end of
> table. When I open my
> >table I want the last set of records to be fetched and as I
> scroll up prior
> >records to be fetched, is there any way to do this?
>
> Yes. Throw the TIBOTable out of the window and use a TIBOQuery or
> TIB_Query. Then you can get the benefit of what SQL is all
> about - ask for
> a descending ordered set (ORDER BY) and restrict the rows
> using a WHERE
> clause (since most humans could not read 300,000 rows in a day!!)
>
> Table components are for spreadsheet-style applications on
> desktops, not
> for client/server systems. You can't do much with them at
> all, except
> block up your network.
>
>
> > I'm using Delphi 6, IBO 4.0 (should I download the 4.5
> version?) and
> >Interbase 7.1
>
> IBO 4.0 was a beta series from the first half of 2001! So, yes, I'd
> suggest it's a good idea to come up with the times. :-)
>
> Helen