Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remote data - multiple row update style
Message
From
09/11/2000 12:13:42
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Internet applications
Title:
Remote data - multiple row update style
Miscellaneous
Thread ID:
00439772
Message ID:
00439772
Views:
62
I've got the following situation:

1) Web based entry form w/ grid that has updatable fields - must keep this interface. The grid data is child data.
2) Passing data from ASP page, to VFP business object for validation. Data is passed in an ADO-like array. (rather than ADO RS, per MS suggestion)
3) The child data may include new records, updated records and records flagged for deletion.
4) For the majority of screens that work this way, child data would be fewer than 10 fields, and fewer that 20 rows.

Here's the question:

Would it be better - from whatever standpoint (design, i/o, etc.) - once the validation is passed to handle the actual data modifications...
1) .. one row at time, performing the appropriate action for each. i.e., update row 1, delete row 2, insert row 3, etc.
2) .. by deleting all related child data, and inserting the given data.

The backend would be Oracle.
Insanity: Doing the same thing over and over and expecting different results.
Reply
Map
View

Click here to load this message in the networking platform