Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is the Pack command really dangerous?
Message
From
13/12/2000 12:48:19
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00451943
Message ID:
00452966
Views:
40
Hi Dave.

>If I recreate the indexes, will the relational links between my tables need to be recreated too?

Yes, because persistent relations are based on indexes. So, DELETE TAG not only removes an index from the table, but also any persistent relations in the DBC based on that index.

Stonefield Database Toolkit (SDT) handles this automatically. You just call the Reindex method and it takes care of the rest.

>There won't be any changes to the physical structure of the DBC, tables, or indexes. Thus, I'm assuming that the cdx files will pretty much maintain their integrity for a fair amount of time. Is this a wrong assumption?

Unfortunately, lots of things can cause indexes to become corrupted, such as a user rebooting, a workstation or server crash, flaky network cards, etc.

Doug
Previous
Reply
Map
View

Click here to load this message in the networking platform