>
>>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?
>>
>>How do you know that only one record has been recalled?>
>Because when I browse the table after the recall, that's exactly what appears to have happened. In the interim, I've been able to determine that the insert trigger is what's causing the issue.
>
>That said, I'm not clear yet as to why the trigger could be limiting the recall to one record.
Why Insert trigger is getting called on Recall ?
If it's not broken, fix it until it is.
My Blog