Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Delete child records, when parent record is deleted
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00523079
Message ID:
00523119
Views:
12
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
Previous
Reply
Map
View

Click here to load this message in the networking platform