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?
Thanks,
Stacy
Black Mountain Software, Inc.