General information
Category:
The Mere Mortals .NET Framework
Title:
Bizobj updates unchanged rows.
I have a Parent-Child form very similar to the CustomerOrdersForm. When I insert, update, or delete any row of the child business object all rows are updated on SQL-Server. So if I have 20 child rows and I delete 3 of them I get 57 updates in the database. If I add 3 I get 63 updates. I know this is happening because the update triggers are firing.
This is not a good thing. Especially since the framework insists on committing to the database after each row is added or deleted. What I want to happen is this:
I add 3 rows in the child grid without updating anything in the database. When I click the save button, and not before, I get 3 inserts in the database. I delete 3 rows and, when I click the save button, I get 3 deletes in the database. I a row and click save and I get 1 update not 20.
This is an obvious requirement. What do I have to set to make my form work that way?
Thanks,
Max...
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only