Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Editing multiple records of a table in the same form
Message
De
16/09/2009 12:22:33
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01424677
Message ID:
01424757
Vues:
52
>> could it be possibly done by using a single view?
>
>No, views don't work particularly well with more than one update table. While changes appear to work, you get into real problems when you delete one of the n-records. As there's only one deleted flag, this would also delete the parent record which often cascades and deletes all other child records, as well. The rule of thumb is one updateable table per view.

Hi,

Thanks for pointing out this delete problem, although it is not a real problem this time...

The reason I don't want to use grid is because the 1+N records are logically bound as one entity, that is when ADD, 1+N records must be appended at the sametime and the samething apply to deletion.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform