Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Best way to add child recs?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Divers
Thread ID:
00069309
Message ID:
00069445
Vues:
29
>Hi John,
>
>Do not know about golden ideas, but here is how I proceed:
>
>I clone the child table, append empty records and submit that to the grid. The validation of the fields allows the user to go back and forth, gives him a kind of an Spreadheet feel.
>
>At save time the clone is copied into that master child table under a transaction scheme. If anything goes wrong, the system rolls back.
>
>Old documents are loaded by copying the add hoc records into the clone. Lines that cannot be changed are locked. At save time, I delete eventually deleted records (the clone keeps the records but tags them as deleted) and overwrite changed records, and add new records.
>
>New line entries do not require any button pushing, the system simply goes to the next line. Delete does have a button, and so has Save.
>
>HTH and otherwise, I wish you a very good year 1998.
>
>Marc
Marc, best wishes to you in 1998 too!
I actually though about doing something like that but decided against it. The problem was data-validation. Since I'm using two field key for each line-item (for details please see my message to Barbara), I couldn't find an elegant way of doing validation using the grid for data entry. Please don't misunderstand my point. I do use methods similar to yours in other scenarios myself but I don't thinks it's appropriate for this purpose.

Thanks.
John.
It's "my" world. You're just living in it.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform