Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Corrupt table
Message
De
28/09/2006 19:30:32
Neil Mc Donald
Cencom Systems P/L
The Sun, Australie
 
 
À
28/09/2006 11:30:56
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Versions des environnements
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
01157866
Message ID:
01158023
Vues:
28
Hi,
Sounds like you have corruption like non hex in a memo field i.e. invalid memo file block pointers, just browse the file to see if you can identify the corruption.

>OK this is a first for me. I have a table "emwosb" that is corrupt but I can't fix it.
>
>reccount() = 424625
>pack
>reccount() = 424625
>copy all to testdbf
>use testdbf
>reccount() = 424621
>
>In a program I use "emwosb" and then set a filter. Then attempt to "scan". The program just sends the CPU to 50% but does not move forward (to the next statement).
>
>I have:
>select emwosb
>copy all to table
>zap
>append from table
>
>Still the scan fails.
>
>The table is indexed and I have removed the index (cdx) and it still goes nuts on the scan.
>
>I have removed the table from the DBC. Used the table as a free table copied the records to a new table renamed and then added back into the DBC. Same issues.
>
>Anybody have a suggestion on what to do next?
>
>John
Regards N Mc Donald
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform