Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Optimal SET TABLEVALIDATE
Message
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00920935
Message ID:
00920956
Vues:
22
This message has been marked as the solution to the initial question of the thread.
>VFP8 SP1, SET TABLEVALIDATE got new argument values. What would be the SET TABLEVALIDATE that is reasonably safe and doesn't slow dbf manipulation?

Any setting, besides 0 will slow access to a table. You've to decide which one is acceptable for you. I would recomend 7 or 15.

>Another question along the line.
>How does SET TABLEVALIDATE 2 (When records are appended (or inserted) and written to disk, the record count is validated) differ from SET TABLEVALIDATE 8 (Check table (.dbf) header before append operation is saved to disk and the header is modified. This affects insert operations)?

With SET TABLEVALIDATE 2 the check is performed after record is added. If record count in the header was -1 before that than corruption will not be detected because it'll be correct after append. SET TABLEVALIDATE 8 performs an aditional check before record is appended.
--sb--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform