Subject Re: [IBO] Two datasets, One inserted, Other updated fetching
Author Geoff Worboys
> I want to use two datasets for performance reasons. In order to
> choose which record to edit, the user doesn't need to see all
> information (blobs, lookups, details datasets) .

> I forgot to say that I'm using TIB_Query.

Set FetchWholeRows = false and IBO will manage this automatically.

When FetchWholeRows is false IBO sets up an special statement that
only returns key values, and a separate statement that returns the
entire row for specific (key located) records. The full rows are only
retrieved for rows that are specifically referenced.

Entire rows will be fetched for each IB_Grid row that is displayed,
but the performance impact of this should be minimal. Performance in
such cases is usually only a problem when returning thousands of
records (and your grid wont be large enough to display thousands of
records at a time).


Geoff Worboys
Telesis Computing