Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Mystery with recalling deleted records
Message
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01454590
Message ID:
01454596
Views:
48
>>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform