Problem saving detail in mstr/dtl application.

From: Debbie Erickson (knmc_at_montereypark.ca.gov)
Date: 03/22/04 

Date: Mon, 22 Mar 2004 09:42:08 -0800

If I edit my master record, then edit the detail, both will save correctly.
But if I try to modify the detail without changing the master, my screen
controls "appear" to be correct, but the actual data never gets written out
to the database.

A bit of background: I use adodatasets, where I link the detail to the
mastersource. I also have client datasets and a dataset provider. The
datasetfield is set on the detailCD. In the beforeedit, before insert,
before delete events of the detailcd, I check the status of the mastercd.
If it is in browse mode, I force the mastercd into edit status. I do the
applyupdates within a transaction block. As I trace the program, it looks
like it follows the same logic path when I save a record, whether the master
contained changed data or not.

I have one master with several fields on the screen, and one dbgrid to allow
entry of the detail. When I add or delete a detail record, the grid looks
like the detail was added/removed.

What are some common mistakes that may cause the detail not to update
correctly? I see another poster, Joao Kho with a similiar question. Except
he's using the batch approach whereas I am using the transactional method.

Relevant Pages

  • Re: RUSH - Need Help w/ Master Slide Background Graphics
    ... either the logos are in the background and you can't edit them. ... Also, when the logo has been inserted on the mother master, the one at the top, the logo will be copied to the other slide layouts, but you won't be able to select them there. ... can't select the graphics, it's probably inserted as a background, which ...
    (microsoft.public.powerpoint)
  • Re: Great SWT Program
    ... I've explained already how this illusion works. ... They're all typically 7-bit ASCII. ... the file, edit, and rename it back, for instance. ... jack of all trades or master of one. ...
    (comp.lang.java.programmer)
  • Re: Header/footer/page number problem
    ... the Master page, if you put anything on the Master page it will be on all pages. ... Everything looks fine -- until I decided to add headers. ... when I try to follow these instructions: "In the Edit Master Pages ...
    (microsoft.public.publisher)
  • Merging in Publisher 2002
    ... I import into a master or main document, but if I edit ... let's say that I only want Jane Doe to be ...
    (microsoft.public.publisher)
  • Re: More than one password?
    ... for worksheets and then for worksheets in xl2002 and later, ... > Click on Tools Menu -> Allow User to Edit Ranges ... > Enter YOUR 'Master' password in the Range Password and click on OK. ...
    (microsoft.public.excel.programming)