Re: Cascade Delete Not Working Correctly?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: James Goodman (james_at_norton-associates.REMOVE.co.uk)
Date: 03/25/04 

Date: Thu, 25 Mar 2004 15:48:16 +0000 (UTC)

In order to do this you will need to enable Cascade Update as well as
Cascade Delete... 

-- 
James Goodman
MCSE MCDBA
http://www.angelfire.com/sports/f1pictures/
"HarryArchibald" <HarryArchibald@hotmail.com> wrote in message
news:ec2901c4127b$e58cbde0$a001280a@phx.gbl...
> 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

  • Cascade Delete Not Working Correctly?
    ... 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: 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)
  • Re: Relationship Question
    ... should uncheck cascade update/deletes). ... master table) the primary table will contain unique values. ... If you have checked cascased update and cascade delete, ... delete/add whatever you want. ...
    (comp.databases.ms-access)
  • Re: How to deal with cascading changes?
    ... I really am;) but I am not getting the remark on delete/insert. ... The cascade will be performed whenever I call UPDATE on the PK column even ... >>change is cascaded in SQL Server to many other child tables. ... >> the update command still uses the original key from the original row data ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Delete button isnt working
    ... I've also tried the compact and repair the database, ... "John W. Vinson" wrote: ... to delete the parent record as long as child records exist, ... Cascade Deletes checked on the relationship. ...
    (microsoft.public.access.forms)