Updating order of DataTables
-
Hi, Hi I have 3 tables, one is master table( EMP) and other two are child tables (Emp_Dep and Emp_Jone). Example: EMP EmpId Name 1 ABC 2 XYZ Emp_Dep EmpId DepId 1 2 Emp_Jone EmpId JoneId 1 4 I have created these 3 tables and defined Relation objects between these three tables. My problem is the order of updating in my application, Case1: If I update the tables in Emp_jone, Emp_Dep and Emp order, I am getting “constrain failed” exception, when I have add a new employee and linked with a Department and Jone. This would be resolved if I update in Emp, Emp_Jone and Emp_Dep order Case2: If I deleted an existing employee, who has been liked with some Department and jone, and I update in Emp, Emp_Jone and Emp_Dep, I will get same constrain failed exception, to resolve this I will have to update as specified in Case1 order. Could you please give me some suggestion to resolve this without any intermediate updates? Regards, Satish
Satish