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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only