>>problem: table will not accept new records
>>
>>fix: copy table to another location
>> zap and pack the table
>> append records from the copied table
>>
>>The table works fine again...
>>
>>
>>
>>This type of corruption usually can be linked with some type of power loss or catastrophy on a workstation with files open.
>>
>>
>>If a file is corrupted in this way, it does not seem to return errors when running transactions such as:
>>
>>
>>local jrollback
>>jrollback=.f.
>>
>>BEGIN TRANS
>>
>> do stuff...
>>
>>if !tableupdate(.t.,.t.,'table')
>> jrollback=.t.
>>endif
>>
>>
>>if jrollback=.t.
>> ROLLBACK
>>else
>> END TRANS
>>endif
>>
>>
>>The transaction thinks that everything is fine and the tableupdate succeeds with no problems while no record is added to the table.
>>
see other items in the thread...
The best workaround is to use SDT from Stonefield...
I had been manually copying the table to another location, zapping and packing the local table and then appending from the copied table (pain in the neck)
The SDT solution is much better.
>
>
>>I have seen this happen a small number of times. Has anyone else had experience with this?
>
>I have seen similar stuff when indexes get corrupted. Do you have a workaround for this behavior?
Thanks,
Stacy
Black Mountain Software, Inc.