Subject Re: [IBO] Transaction with master-child relationship
Author Helen Borrie
At 10:29 AM 8/12/2003 +0000, you wrote:
>--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@t...> wrote:
> > At 09:53 AM 8/12/2003 +0000, you wrote:
> >
> >
> > >KeyLinks of QueryAddress:
> > > ADDRESS.ID
> > > ADDRESS.ADDRESS_TYPE
> > >
> > >KeySource: *Blank*
> > >
> > >MasterSource: DSCustomer
> > >MasterLinks: ADDRESS.ID=CUSTOMER.CUST_ID
> >
> > Do you have the RequestLive property set true in the detail set?
>
>Yes, the RequestLive property for both queries are set to true.
>Basically the funny part is, why does it work when I use
>IB_TransactionBar to commit. The rest of the setup should be correct
>because I followed the tutorial's setup closely. Weird right?

It only suggests *something* is missing that prevents the detail rows from
getting posted until the transaction is finally committed. Does this occur
with every detail insert, or just the last one? It could be that you are
not calling Post on detail rows that don't get posted in the OnNewRow event
for the succeeding insert...what the transaction bar achieves, that your
code does not, is to test the NeedToPost properties of all datasets before
calling Commit.

Helen