Subject Re: [IBO] Newby - which component to use
Author Jason Wharton
If you use the TIBOTable component it will do just as you are suggesting.
If you press Last it will dump the buffer and fetch only the records at the
end of the dataset. All Locate() calls, bookmarks being set, etc. will cause
it to dump the current buffer (if the record isn't already in memory) and
fetch just the records adjacent to the one desired forward and backward. If
you call First, you guessed it, it dumps the buffer and fetches just the
first records of the dataset.

All of this has been (or will be) properly integrated with cached updates,
selection of rows, etc. Each record that has special flags set for it will
remain tied to the bookmark in a secondary cache and maintain their
effectiveness even though other records are dumped when they become

I hope this makes sense.

Jason Wharton
CPS - Mesa AZ

----- Original Message -----
From: "gigmbh" <ZJQBBYSESPEZ@...>
To: <>
Sent: Friday, January 11, 2002 10:12 AM
Subject: Re: [IBO] Newby - which component to use

> > If you need to scan all records from first to last use a TIB_Cursor.
> That's what I would normally do (e.g. for report generation)
> But what I try to avoid is if I present a grid control to the user
> which represents a really large dataset that he will scroll around
> and fill up memory of the ws. It seem that IBO does many tricky
> things e.g. with asc. and dec. keys. Isn't there a way to free
> buffered records and us a descending key for scrolling back in the
> grid ?
> Sorry for so many questions but it is really much to investigate and
> to learn before you could use such powerful tools in the right way.
> Regards,
> Frank.