Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Advantages/disadvantages of DBCs
Message
 
À
27/05/2010 10:17:43
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP2
Divers
Thread ID:
01466065
Message ID:
01466273
Vues:
67
>"can be more difficult to recover". Hmm... That's converning, because I have had a few instances where some of my dbfs will get junked up with some "Table Has Become Corrupted" error, and I use a prg that I found somewhere that fixes up the file header with some pretty low-level code to make it work again. Always scary, but so far, it has worked every time.
>
>So, since that prg messes with the dbf file like that, I guess it's possible that it could break the linking between the file and the dbc.
>
>Can you elaborate on any problems you've had or know of, and what the actual remedy is/was?

Simple table header issues are never a problem for tables in a .DBC

Here are some things I've run into:
1. The table appears fine but there is a problem with the DBC, but VALIDATE DATABASE RECOVER has issues with the table. So
you have to hack the .DBC to remove references (index, etc) so you can validate the database so that you can recover the table.

2. The table is really FUBAR'd and removing it (temporarily) from the datbase to make recovery life easier results in all your long field names now truncated to 10 characters, even if you reattach it.

3. Primary Key enforcement from the .DBC on a table which has become corrupt can make recovering the table more difficult.

I've run into other scenarios too which the .DBC makes harder. Invariably, with this really FUBAR data, the customer was using Wi-Fi which we always tell them not to do, but they do anyway.


Obviously all these issues go away if the database is MS SQL, MySQL, etc.
Brandon Harker
Sebae Data Solutions
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform