Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Remote data - multiple row update style
Message
De
09/11/2000 12:13:42
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Applications Internet
Titre:
Remote data - multiple row update style
Divers
Thread ID:
00439772
Message ID:
00439772
Vues:
64
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.
Répondre
Fil
Voir

Click here to load this message in the networking platform