May 4, 2013 at 3:15 pm
I have two tables and I keep getting an FK conflict error on some of the data being inserted and cannot work out why!
May 4, 2013 at 6:23 pm
Because you have made foreign key as MatchID, where as it should be Venue ID.
CONSTRAINT fk_VenueID FOREIGN KEY (MatchID)
It should be :-
CONSTRAINT fk_VenueID FOREIGN KEY (VenueID)
You create 10 rows for Venue table so after. SO there are 1-10 venue id and when you try to insert 11th row in Match table, you get FK violation error.
May 5, 2013 at 3:43 am
Thank you very much, that has solved that problem but also created another which probably needs a similar fix!
When I try to insert data into my MatNat table, it only does the first 10 and ignores everything after!
May 5, 2013 at 5:18 am
What error it is giving. You have given data for only MatNat table, so I can't replicate it.
But Check the value of Hotel, Nation & Match Table to see if the value exists in these tables what you are trying to insert.
May 5, 2013 at 5:25 am
Have Pm'ed you
May 5, 2013 at 5:37 am
Thanks!:-)
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy