[SQL] Mechanics of Update:Cascade

2004-01-31 Thread beyaRecords - The home Urban music
Hi, could someone please explain to me the mechanics of an UpDate:Cascade? Delete:Cascade I fully understand but not Update. I have 2 tables A and B. On B I have created a foreign key on user_id in both B and A for Update and Delete cascade. If I delete from A it deletes all from B. If I

Re: [SQL] Mechanics of Update:Cascade

2004-01-31 Thread Stephan Szabo
On Sat, 31 Jan 2004, beyaRecords - The home Urban music wrote: Hi, could someone please explain to me the mechanics of an UpDate:Cascade? Delete:Cascade I fully understand but not Update. I have 2 tables A and B. On B I have created a foreign key on user_id in both B and A for Update and

Re: [SQL] Mechanics of Update:Cascade

2004-01-31 Thread Richard Huxton
On Saturday 31 January 2004 10:50, beyaRecords - The home Urban music wrote: Hi, could someone please explain to me the mechanics of an UpDate:Cascade? Delete:Cascade I fully understand but not Update. I have 2 tables A and B. On B I have created a foreign key on user_id in both B and A for

[SQL] Mechanics of UpDate:Cascade

2004-01-31 Thread beyaNet Consultancy
Hi, could someone please explain to me the mechanics of an UpDate:Cascade? Delete:Cascade I fully understand but not Update. I have 2 tables A and B. On B I have created a foreign key on user_id in both B and A for Update and Delete cascade. If I delete from A it deletes all from B. If I