Cascade Delete Not Working Correctly?

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: HarryArchibald (HarryArchibald_at_hotmail.com)
Date: 03/25/04 

Date: Thu, 25 Mar 2004 07:14:41 -0800

I have a master table that is updated. The master has
child records that are referenced by a foreign key with
the CASCADE DELETE option.

In the transaction log, an update of the master appears
as a DELETE/INSERT. The primary key is not being updated.
  
For the child record, the same update appears to
DELETE/INSERT the child.

Occassionaly, when a master record is updated, the child
record is deleted but not inserted.

Can anyone explain why?

TIA,
Harry

Relevant Pages

  • Re: Cascade Delete Not Working Correctly?
    ... In order to do this you will need to enable Cascade Update as well as ... > I have a master table that is updated. ... > child records that are referenced by a foreign key with ... > DELETE/INSERT the child. ...
    (microsoft.public.sqlserver.server)
  • Re: Non-updateable query issue
    ... record for each master table record, ... they aren't child records -- it's a 1:1 ... PersonID Phone ... editing the same data at the same time (it also makes it easier to ...
    (microsoft.public.access.queries)
  • Re: Cascade Delete Not Working Correctly?
    ... master record results in an delete/insert of the child. ... >In order to do this you will need to enable Cascade ... >> child records that are referenced by a foreign key with ...
    (microsoft.public.sqlserver.server)
  • Rowfilter on child recorsd only works with Fill
    ... I want to filter parent records so that only those ... which don't have child records are listed. ... Master, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Help with foreign keys
    ... one that uses a local Access 2007 database. ... UserID varCharNOT NULL FOREIGN KEY REFERENCES Users, ... So, if we have Customers, and Invoices tables, a left join would give us: ... REGARDLESS if the child records ...
    (microsoft.public.access.gettingstarted)