Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Why i cannot delete the records
Message
De
09/06/1998 00:06:38
 
 
À
08/06/1998 12:28:47
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Divers
Thread ID:
00105004
Message ID:
00106167
Vues:
27
Hello Dennis, >You said that the better way is to have Delete trigger for Idetail table. >How can i do this ? You should have a Primary key index in your invoice table and related Foreign key index in your Idetail table. Then, in your DBC designer establish permanent relation between tables (drag-n-drop primary key index over foreign key index). And, finally, right click over this permanent relation (thick line between tables) and you choose Referential integrity item. You'll get the form where you have the choice between Insert/Delete/Update triggers for each couple of related tables. In DELETE option choose Delete. After this done, you'll have a delete trigger that will delete all related records from Idetail table whenever you'll delete a record from Invoice table. >Hope you can teach me ? Hope this help, if something is unclear, feel free to ask again
* Human is a question asked by birth and answered by death. Machine is another kind of question with another kind of answer
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform