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

<--
Wouldn't the child records already have the parent code at the point where you save the DataSet?
>

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.

No. Here's the scenario:
1- Create new record (1). parent code is null.
2- Create new record (2). parent code is null.
3- Modify record (1) and set parent code = (2).

Now, how do we handle such cases during batch update?

Thanks
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform