Jim,
I've now been able to read the details of the SET TABLEVALIDATE command that is new in VFP8.
I'd just like to verify that I am correctly interpreting its operation as regards the parameter value of "2". The Help says for
nLevel=2 says
Validate record count when appending or inserting records and writing them to disk.I interpret this as saying that the header's record count is verified before every write to the table and I assume that there will be an error message if a discrepancy is encountered.
Assuming that to be correct I would say that I can achieve perfectly adequate "protection" running with
nLevel=2 as with it equal to 1 or 3. Would youu agree?
Thanks for your comments
>We added SET TABLEVALIDATE to VFP8 after the public beta, so you can SET TABLEVALIDATE TO 0 to turn off the checking, then USE and PACK the table, all in VFP8.
>
>>Now I seem to recollect that VFP8 has been changed to assist in mitigating the impact of the MSKB #
293638 and that the recommended fix is to open the table using VFP7 and PACK it. This of course may have changed in the final version, but this is what I remember from the VFP public beta Help for a new error message near the end of that part of the Help.
>>