Mensaje
De
15/03/2010 14:47:37
a
15/03/2010 12:29:12
General information
Foro:
Visual FoxPro
Category:
Bases de datos, tablas, vistas, índices y SQL
Título:
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
ID de la conversación:
01454590
ID del mensaje:
01454631
Views:
47
>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?
Try
>
>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?
Try
SET ORDER TO 0 RECALL ALLThe index that currently in uses maybe throwing the record pointer to near the end of the table.
Greg Reichert