Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 11 to 15 of 15 total |
CachedUpdates with m/d |
Thu, Jul 27 2006 11:41 AM | Permanent Link |
"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? 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 > > |
Fri, Jul 28 2006 9:49 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@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 |
Fri, Jul 28 2006 11:32 AM | Permanent Link |
"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 ? 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 |
Sun, Jul 30 2006 1:01 PM | Permanent Link |
"Sorin" | Tim
I'll like to send you a small demo program that will clarify my problem To where I can send it? Sorin |
Sun, Jul 30 2006 1:35 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
« Previous Page | Page 2 of 2 | |
Jump to Page: 1 2 |
This web page was last updated on Tuesday, April 30, 2024 at 03:55 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |