On 16 Aug 2001, at 0:53, Helen Borrie wrote:

> >So what do I need to do to make the combo-box refresh it's data?

> I agree with Luc, if you want a combo box whose list has to stay in
> sync with the other dataset, you need the data-aware list that
> tib_lookupcombo provides. You *could* write a LoadComboBox routine
> that clears and loads the combobox list both at FormCreate and
> whenever a row from dataset A gets posted but this is expensive and
> loses you the benefit of watching Bookmarks in dataset A and using
> them to refresh just the changed row in the list of a lookupcombo.

Actually it is a TIB_LookupCombo, slip of the brain while typing....

> As was suggested, the dataset for the lookupcombo would need to be
> inside a READ COMMITTED transaction for it to pick up the refreshes
> from dataset A. rgds Helen

Okay, so I set the transaaction isolation to tiCommitted on both
transactions. And both are marked as AutoCommit = True.

Now, I did some more experimenting, I deleted an existing record,
from TABLE-A, and the TIB_LookupCombo no longer show those records,
but refuses to show new ones, until I exit and restart the
application.

Paul



Paul Schmidt,
Tricat Technologies
Email: paul@...
Website: www.tricattechnologies.com