>>>If say, you would be using an SP to update all 3 tables at once, you would not have this problem, but the question is how to pass parameters?
>>>
>>>In SQL Server 2005 you may pass XML as a parameter, but I don't think it would ease the process.
>>>
>>>E.g. if you somehow pass curUpdateTable1.XML (all updated fields for 1 table), same for the second and the third - I'm not sure how can you now handle it in SQL Server.
>>>
>>>How can we pass updated values for the fields in this SP?
>>>
>>
>>I am not using SP for the updates. And I would like to keep updates of each module done via the module Business/DA class. So passing XML or doing anything in SP is not applicable for me here.
>>
>>Thank you for your suggestion.
>
>In MereMortals this is done through Parent - Child relationship. The Parent class starts the transaction, then Saves, then try to Save all children...
Too bad I am not familiar on how they (MereMortals) actually implement this type of approach, Parent and Child Classes.
Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham