• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

howto update dataset in this scenerio?

anupam_sam

OSNN One Post Wonder
#1
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:
 

Members online

No members online now.

Latest posts

Latest profile posts

Hello, is there anybody in there? Just nod if you can hear me ...
Xie
What a long strange trip it's been. =)

Forum statistics

Threads
61,961
Messages
673,239
Members
89,014
Latest member
sanoravies