Reply
Old July 22nd, 2006 Top | #1
 
anupam_sam's Avatar
OSNN Junior Addict
Joined: May 2006
Posts: 3
Reputation: 0
Power: 0

Post howto update dataset in this scenerio?

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?
anupam_sam is offline   Reply With Quote

Reply

Bookmarks

Thread Tools

Posting Rules

Similar Threads
Thread Thread Starter Forum Replies Last Post
Sitemap howto Heeter Web Design & Coding 6 January 30th, 2008 7:36pm
CentOS 4.1 MailServer Howto Heeter Linux & BSD 10 August 22nd, 2005 9:11am
Lockdown 11B howto Heeter General Hardware 2 September 23rd, 2003 12:49pm
Howto: .html reading .xml lieb39 Web Design & Coding 2 September 6th, 2003 2:22am
howto? - Backup ViceCity cds lieb39 Windows Desktop Systems 53 May 19th, 2003 10:39pm