Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C#3.0 .NET3.5
i have three tables in data base.parent table have to foreign key which are primary keys for the other tables.i want to update the tables and i want to change the foreign key .but i am getting error.how can i update foreign key help me.
Posted 31-Aug-12 22:59pm
Comments
Sandeep Mewara at 1-Sep-12 6:49am
   
What/How were you trying to update? What error were you getting?
 
You can change the relation FK from one FK to other but cannot modify the FK number.
Christian Amado at 2-Sep-12 11:31am
   
What's the error here?
Roliking at 2-Sep-12 12:49pm
   
you need to make sure the fk you are trying to update is present as a pk in the table which the fk is mapped to.
 
It would be helpful if you provide some code and the error that you are getting.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 493
1 Sergey Alexandrovich Kryukov 213
2 PhilLenoir 150
3 RyanDev 115
4 RajeeshMenoth 110
0 Sergey Alexandrovich Kryukov 6,415
1 OriginalGriff 5,856
2 CPallini 2,473
3 Richard MacCutchan 1,667
4 Abhinav S 1,530


Advertise | Privacy | Mobile
Web04 | 2.8.140821.2 | Last Updated 1 Sep 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100