Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Record moves with the table relation?
Message
De
29/05/1998 10:11:28
 
 
À
29/05/1998 10:06:30
Tan Gay Cheong
Cybercomp Computer Services
Singapore, Singapour
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Divers
Thread ID:
00103076
Message ID:
00103080
Vues:
30
>I have a questions, does the child table's pointer the same as the parent?
>
>If i delete a record on the parent table, will the child table goes the same record number as the parent do?
>
>Or should i set triggers to do so?
>
>I am trying to move the tables together in a form, but don't seem to be getting the right way. Can anyone explain to me how to make the tables work in the form?
>
>I have set three tables in the datasession of the form, what can i do from here?

Child table has own pointer which moves in accordance with parent table pointer if you set temporary relationships (which IMO is bad practice). When you delete a record in parent table, child records still exists and, because deletion itself doesn't move pointer yet, then child pointer is on the same place. If you want to delete child record(s) too, then you could implement RI Delete Cascade Trigger.
Edward Pikman
Independent Consultant
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform