On 15 Aug 2001, at 9:43, Jason Wharton wrote:

>
> > Okay, so I set the transaction 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.
>
> Perhaps you are needing to use the DML Caching feature of IBO?
> See the tech info sheets available on the web. There is one dedicated
> to this topic.

I don't know if DML Caching will help, the form calls the refresh
method on the TABLEA dataset. when the form is activated, so
shouldn't that reload the data into the LookupCombo? It seems like
it works half way, if I delete a record it's gone, but if I add a
record it's not getting added to the lookup combo. I can't use the
same Dataset because the SQL is slightly different.

Paul






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