Re: deleting detail record

You need to call ApplyUpdates in reverse order.
You need to call ApplyUpdates for the Detail Dataset first and then for the
master dataset.
I think once you applyupdates for the master it must do something to the
detail datasetto cancel the batch update or something, because I had the
exact same problem until I reversed the order.


"CC" <dontbother@xxxxxxxxxxxxxx> wrote in message
news:2f8q135ungsk9g766qo1m1ihi5mm0ftd6b@xxxxxxxxxx
On Wed, 11 Apr 2007 10:12:13 +0200, "Cavalera Guido"
<cavaleraguido@xxxxxxxxxxxx> wrote:

excuse me i think i must explaining better the problem :

when i delete a master record in M/D relation first i delete datail
records
and then master ! Ok ....When i do UpdateBact in a master and detail
dataset
only master record is really deleted on the database but detail NO !!!

This is an adodataset bug i think ! have u solved that ?

You might want to set the relationship of the tables to "cascading
deletes". That way, whenever you delete a master record, the SQL
server does the detail deletes for you automatically.

You set this in the RI (relational integrity) section.


.

Relevant Pages