Hello Everyone,
I have a quick question.
Let's say you have the following situation. You have a parent table and a
child table. If I wanted to update both parent and child at the same time.
What would be the best way to do this. The reason why I am asking. Doing
two different inserts might be a bad idea. The reason being, what is the
first insert works, and the second one fail. If you have any suggestions
that would be great.
Thanks,
Mark
Justin Rogers - 27 Oct 2004 01:31 GMT
Not sure of your back-end technology, but the solution here is something
you might call a transaction. Transactions allow for failure situations to
result in a rollback to an original state.

Signature
Justin Rogers
DigiTec Web Consultants, LLC.
Blog: http://weblogs.asp.net/justin_rogers
> Hello Everyone,
>
[quoted text clipped - 9 lines]
> Thanks,
> Mark
GrkEngineer - 19 Apr 2005 01:38 GMT
You might want to check out a Document/View architecture. One document and
multiple views would give you what you're looking for.
GrkEngineer
> Hello Everyone,
>
[quoted text clipped - 9 lines]
> Thanks,
> Mark