in table department i've class_id as f.k and in class table class_id as p.k
i want to update class_id in department table..
n getting error
dew97 0
Newbie Poster
Recommended Answers
Jump to PostIt should only give you an error in the "department" table if the F/K does not exist in the "class" table.
What is the error text you are receiving?
Also, what is the specific action you are doing in the department table?
All 2 Replies
thines01 401
Postaholic Team Colleague Featured Poster
It should only give you an error in the "department" table if the F/K does not exist in the "class" table.
What is the error text you are receiving?
Also, what is the specific action you are doing in the department table?
Reverend Jim 4,780
Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster
Can you please avoid convenient (for you) abbreviations? I assume f.k and p.k are foreign and primary keys. Also, some context would be nice. If you want help please do us the courtesy of providing as much information as you can. For example
1) how about some code for us to look at and a line number where the error occurs
2) how about an error number and description
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.