Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>>>hellow !!!!!!!
>>>>one of the indexes in one of my tables that is in database was damaged.
>>>>after reindex operation i found out that 1000 records where missing.
>>>>i took the same table from my backup (before the reindex operation), erased the cdx file and open the table without index.
>>>>the records where still missing.
>>>>how can it be
>>>>help !!!!!!!
>>>
>>>They were deleted via some other action. Reindexing does not do anything to the records in the table. It merely scans the table and builds a separate file with pointers to those records.
>>>
>>>Have you run a pack recently? This does manipulate the table so it could have done something to the table.
>>
>>>I did not run pack operation but i did found a virus (not in that table).
>>Can a virus cause this problem
>
>It could have. If the table header was manipulated in some way, you could lose the ability to see some records.
>
>Another possibility is a corrupt table header. This could cause problems adding new records. They would appear to be added (VFP would report success with no errors) but they would not be be. Doug Henning has a couple of messages on this topic. Do a search for messages from him about this for more information.
Probably i have a problem with the table header (once in a while i add records and then i cant find it).
i will serch more information thank you all
oz
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement