Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Self referencing tables
Message
 
To
21/07/2003 02:19:11
General information
Forum:
ASP.NET
Category:
The Mere Mortals .NET Framework
Miscellaneous
Thread ID:
00811710
Message ID:
00812090
Views:
20
Houssam,

>Yes, but what is exactly the order of update? If its: the first record updated gets first to the database, then the child record will get there first and we will get an error. Since at this point, the parent does not yet exist, bits its already referenced by the child record.

If you really need to ensure parents are saved first, then children second, you'll need to put them in separate DataTables, or you could even put them in separate DataSets. That way you can always save parent records first, then children second.

Regards,
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com
Previous
Reply
Map
View

Click here to load this message in the networking platform