I have some problem with Foreign Key settings. I use MySQL 4.12, MySQL Query Browser 4.16 and Windows XP. Restrict and Cascade is Ok but when I try to set No action it wont work. Sometimes there is no error message and it seams that the change is saved. But when I check there is no changes. When an error message shows its nr 1005.
What is the conditions to set No action. Ok In the manual it says only that "No action is taken in the child table when rows are deleted from the parent or values in the referenced columns in the parent table are updated." I read the articles on MySQL , a lot of books and the manual but I cant get any answer. Thanks for any answer wich will solve my problem. Sven Åke Johansson [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
