Information générale
Catégorie:
The Mere Mortals .NET Framework
Titre:
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...
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement