I call the BeginCachedUpdates on the second table on the AfterOpen event.
On the form I have a save button wich post the first table and
call ApplycachedUpdates to the second table.
Is that ok?
Sorin


"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message
news:3430F400-2B60-4991-87A5-B1779DEA96ED@news.elevatesoft.com...
> Sorin,
>
> << absolutely, I only call the BeginCacheUpdate to the detail table and i
> encounters 2 problems. The first invoice is saved ok The second one raise
> a key violation error on the primary key (the second table has an autoinc
> field as primary key besides the invoiceNo field >>
>
> Are you calling ApplyCachedUpdates at any time ?  You have to call either
> ApplyCachedUpdates or CancelCachedUpdates to stop the cached updates when
> moving between the master records without posting (CancelCachedUpdates),
> or when posting an invoice (ApplyCachedUpdates).
>
> The demo application that I linked to shows how this is done.
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>
>

Sorin,

<< I call the BeginCachedUpdates on the second table on the AfterOpen event.
On the form I have a save button wich post the first table and call
ApplycachedUpdates to the second table. Is that ok? >>

Yep.  However, what are you doing if the user cancels the whole thing or
scrolls off the main record ?  Are you calling CancelCachedUpdates ?

--
Tim Young
Elevate Software
www.elevatesoft.com

> << I call the BeginCachedUpdates on the second table on the AfterOpen
> event. On the form I have a save button wich post the first table and call
> ApplycachedUpdates to the second table. Is that ok? >>
>
> Yep.  However, what are you doing if the user cancels the whole thing or
> scrolls off the main record ?  Are you calling CancelCachedUpdates ?

If the user doesn't save the data I use the onCloseQuery event and if cancel
is requested I call CancelCachedUpdates.
The user can't scroll from the main record. The 2 tables are open on one
form
in insert or edit mode and the only options are save or cancel
Sorin

Tim
I'll like to send you a small demo program that will clarify my problem
To where I can send it?
Sorin

Sorin,

<<  I'll like to send you a small demo program that will clarify my problem
To where I can send it? >>

Just email it to timyoung@elevatesoft.com

Thanks,

--
Tim Young
Elevate Software
www.elevatesoft.com