>>I have this one table that I'm having problems with when trying to recall deleted records and I'm completely stumped as to what is going on.
>>
>>In my test data, this table has 6 records, 3 of them being deleted. If I attempt a RECALL ALL, only one of the records is undeleted. If I RECALL ALL again, then the second deleted record undeletes. As far as I can see, this seems to be happening only on one table. I ran FoxFix on the table and didn't run into any errors. Could someone shed light onto what might contribute to this weird behavior?
>
>Do you have UNIQUE indexes or some filtered indexes?
>
>Can you show create table structure ?
Finally, did you try
select *, Deleted() as DeletedFlag from myTable into table AttemptToFix
delete for DeletedFlag = .T.
recall all
and see if you have the similar behavior?
If it's not broken, fix it until it is.
My Blog