Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Delete child records, when parent record is deleted
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00523079
Message ID:
00523119
Vues:
14
This message has been marked as a message which has helped to the initial question of the thread.
>>Nadya,
>>
>>Just set delete to cascade for the relation. Open the database, select Edit Referential Integrity from the Database menu, click on the Rules for Deleting tab, scroll to the Regions and TownRegions relation and set to cascade.
>
>Brien,
>
>I'm trying it, but it gives me an error message: "Database should be cleaned up". But this option is disable in the Database menu. What should I do? I already tried to validate database.

Nadya,

Open the database exclusively. Close & reopen fox, issue SET EXCLUSIVE ON, open the database and the menu option should be available.
Brien R. Givens

Brampwood Systems
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform