Subject Re: [IBO] Refreshing Data
Author Geoff Worboys
> Now the problem, when you go back to the country form, it's
> TIBOTable doesn't know that you entered a new country. You
> can call the Refresh function which will reload it, but if
> you had something other then currencies where there might
> be hundreds or thousands of rows, this could take some time.
> So, is there a way of causing it to refresh, only if it
> has changed?

You've already had a response describing the use of events. But I
have a couple of other comments...

Dont use TIBOTable, use TIBOQuery - especially for lookups. So that
you can control the SQL and only select those fields that are actually
required - making a refresh significantly faster.

The last time I used lookups with standard VCL controls (a very long
time ago) it was impractically slow on large datasets. If you really
think that you may need to perform lookups on large datasets you may
want to consider using the native components so that you can have more
control over how the lookup works.

For internal notification of changes, I prefer an internal mechanism
rather that IB events. If you are providing a way of opening a form
to create a missing lookup element, then you should also provide a
feedback mechanism. Perhaps an AfterCommit handler on the form
transaction that broadcasts a message to other forms.


Geoff Worboys
Telesis Computing