Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Mystery with recalling deleted records
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Database:
Visual FoxPro
Divers
Thread ID:
01454590
Message ID:
01454603
Vues:
43
Naomi,

I did try the test code you specified and the records are recalled successfully in the newly created table, as expected. However, I just can't seem to get all the records to recall when working directly with this one problem table. No indexes are filtered.

Jon

>>>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?
Jon Rosenbaum
Devcon Drummer
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform