anupam_sam
OSNN Newbie
- Joined
- 5 May 2006
- Messages
- 3
i have a dataset with 2 tables "Dept" and "Emp". they have a datarelation and emp has a foreign key deptno of dept.
i proceed with following transactions.
1) delete 3 records from child table "Emp"
2) add 1 record to master table "Dept"
3) delete 1 record of master table "Dept" related to those deleted records of "Emp"
4) add 2 corresponding records to "Emp" of that currently added records.
now i want to update these transactions to database.which table i will update first or how this transaction cud be updated?:speechless:
i proceed with following transactions.
1) delete 3 records from child table "Emp"
2) add 1 record to master table "Dept"
3) delete 1 record of master table "Dept" related to those deleted records of "Emp"
4) add 2 corresponding records to "Emp" of that currently added records.
now i want to update these transactions to database.which table i will update first or how this transaction cud be updated?:speechless: