December 2, 2008 at 9:07 pm
Hi
I have couple of tables which have FK relation. Whenever I try deleting a row from these child tables it passes me FK relation error.
Care has been taken to delete row from child table and then from parent table.
I cant make ON DELETE CASCADE ON.
Please help
December 3, 2008 at 2:48 am
Exactly what you want?
Are you getting error after implementing cascade option or wanting to use this cascade option?
December 3, 2008 at 3:10 am
are there child tables that act as parent table for other tables ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
December 3, 2008 at 3:10 am
Probably these "child" tables have Fkey relationships with other tables.
"Keep Trying"
December 3, 2008 at 3:17 am
I cant use ON DELETE CASCADE option.
The table is child table and has only one FK relationship with its PK table.
I'm deleting the record from child table and then parent table. Still I get the error
December 3, 2008 at 3:21 am
Can i have the exact table structures of the parent and child table?
December 3, 2008 at 3:32 am
khushbu.kumar (12/3/2008)
...I'm deleting the record from child table and then parent table. Still I get the error
A parent row can have more than one child rows in a child table....
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
December 3, 2008 at 11:27 pm
ALZDBA (12/3/2008)
khushbu.kumar (12/3/2008)
...I'm deleting the record from child table and then parent table. Still I get the error
A parent row can have more than one child rows in a child table....
Yes.. did'nt think about that. 😉
"Keep Trying"
December 4, 2008 at 12:08 am
I have taken care of deleting all the rows from child table in the query.
December 4, 2008 at 11:46 pm
there can be more than one child table for any parent table..
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply