Click here to Skip to main content
15,937,012 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
hello,
i want to update values in master tables as well as in other table also
eg: empcd in'Employee' and empcd in 'salary' , like this in all tables which contains primary and foreign key values, What is the simplest way to do so?
thanking you..
Posted

1 solution

The simplest way is to insert values that are valid, so you don't get an exception. I assume that means inserting an employee first, then inserting their salary, once the foreign key ( employee ID ) exists.
 
Share this answer
 

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900