Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Corrupted Indexes
Message
De
07/03/2003 08:56:58
Terry Davis
Enhanced systems consulting
Tennessie, États-Unis
 
 
À
18/02/2003 19:17:51
Terry Davis
Enhanced systems consulting
Tennessie, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00753870
Message ID:
00762672
Vues:
16
Jim,
I got side tracked. Back on this issue now.
Question1: In order for me to determine if a table header and/or index is corrupted programatically, can I do the following code in a program:

use table1
set compatible on
nsize1 = reccount()*recsize() + header() + 1
nsize2 = fsize(dbf())
set compatible off
if nsize1 <> nsize2
** this table/index is corrupted, log an error do not replicate
else
** table is good, continue with the replication
endif

Question2: what is the '+ 1' represent in the calculation of nsize1?
Question3: when nsize1 is 1 bit greater than nsize2, what does that indicate? header corruption? Reason I ask is I have a couple of tables in the dbc that has 'nsize1 > nsize2 by 1 bit'. I purchased the Stonefield Toolkit yesterday thinking that I could use it to 'fix' the header/index problems, but when I ran the Repair prg against one of these tables it did not fix it, nsize1 is still 1 bit greater than nsize2. However if I do a copy to table2 with cdx, the new table copy is 'good', nsize1 = nsize2. Problem is the new table looses default values, validation rules, etc.

I need help
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform