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.

I have seen this happen a small number of times. Has anyone else had experience with this?