Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Uhh ohh...table over 2gig - can we open it?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00804445
Message ID:
00804709
Vues:
50
Victor, check VFP help under Table File Structure. This will show you what the header of the DBF file and FPT files look like. You can then get the info you need iro SB's idea.


>hmmmm...interesting idea ... but since VFP won't open the table I'm not going to be able to use the Header() and RecSize() functions.
>
>>Here's an untested idea. Using formula
nLogicalSize = HEADER() + (nRecCount * RECSIZE()) + 1
find the size closest to 2GB but less than that. Use FCHSIZE( ) function to change your table size to that. After that you may try to fix table. As usual, make backup before trying anything. :)
>>
>>>Well I've tried FoxFix, FixFoxPo, FixFox, dSalvage, ATFixDBFPT, smREpair, SalvDB and VFPvw. Anyone have any other ideas?
In the End, we will remember not the words of our enemies, but the silence of our friends - Martin Luther King, Jr.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform