roeya
Posts: 181
|
| Posted: 03/28/2006, 7:03 AM |
|
In CCS updating more then one table without custom code or stored procedure is impossible. However if in custom insert you can select different table for every field it would be welcome addition - in almost every project I create I need multi table update
Insert can have problems if auto generated keys are used however most DBs can get the last inserted key.
_________________
http://www.infoneto.com/ |
 |
 |
Benjamin Krajmalnik
|
| Posted: 03/30/2006, 6:46 PM |
|
How do you propose this to be done, as far as the UI for the developer?
How do you see the serialization of the actual writes to the database?
While theoretically this would be nice, I think it would be much simpler to
hand code it in the insert. I don't think that from a UI you will have the
granularity to control the transaction the way you want it.
I still believe that if the back end supports stored procedures, this is the
best solution in this scenario. That way you can encapsulate everything in a
transaction and be sure nothing will be orphaned. Otherwise, coding it in
the custom insert should work just fine.
|
|
|
|
|
