Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Bizobj updates unchanged rows.
Message
From
03/09/2004 18:02:27
Max Fillmore
Essential Skills, Inc.
Lenexa, Kansas, United States
 
 
To
All
General information
Forum:
ASP.NET
Category:
The Mere Mortals .NET Framework
Title:
Bizobj updates unchanged rows.
Miscellaneous
Thread ID:
00939368
Message ID:
00939368
Views:
64
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
Map
View

Click here to load this message in the networking platform