> Although TIBOTable is much quicker it still is getting
> all the records as soon as the table is opened. So if
> u have thousands of records in database they are all
> fetched as soon as table made active. Isn't there any
> way to tell the table how many records to fetch.

Regarding both this and your previous posting...

Are you using an existing application updated to IBO4 or is this a new
application?

You may find it convenient - while first experimenting with IBO4 - to
try out these issues on a new/sample application, as a way of
determining if such problems are just due to some settings you may
have changed. eg. AutoFetchAll.

Secondly it would help to have some more details about the particular
table and transaction components involved. eg. Post the table and
transaction definition from the dfm file so we can see the SQL and
other settings.

Note that IBO's transaction management may be trying to load all
records (as background processing) so that it can close the
transaction - and avoid OAT issues. This processing depends on
several different properties which is why I suggest you post the
settings from your DFM.


Geoff Worboys
Telesis Computing