Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Network:
Windows 2003 Server
>>I have three tables namely 1. empmain 2. salary 3. recovery. The empid field is common for all three tables. I want to delete the record at once for all tables based on empid field. The empid field is Integer data type.
>>
>>How to delete the record?
>
>If you always want to delete related records in "child tables" when you delete a record in the "parent table", you can set up referential integrity rules in the database. In that case, Visual FoxPro will create the corresponding triggers, in the database, to delete the related records automatically, any time you delete the parent record (even if you delete it manually, for example in a BROWSE window).
I wondered if I should mention RI - if the OPer does not know the syntax, RI probably would be overkill. If the delete was restricted, it was a badly formulated OP ;-))
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement