Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Is it the table close to its bordering ?
Message
De
08/02/2005 13:08:57
 
 
À
08/02/2005 12:45:38
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
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 6 SP5
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
00984751
Message ID:
00984788
Vues:
26
>You could calculate the DBF file size by multiplying the number of records with the size of each record, and adding the header size. But this can't be applied to FPT and CDX files.

What about to use the number of records to have an aprox. proportion ? (on FPT and CDX)
>
>I would recommend just using fsize() or adir(), and get the real file size on disk.
>
>You will never reach the limit for the number of records, without also reaching the limit for the number of bytes: you are limited to 1000 million records and 2000 million bytes (approximate numbers), and each record has at least 2 bytes.

By now, I am facing a weird situation.. I have a table with almost 3 milion of records still accepting data.. And, no kind of message.. If I used RECCOUNT() it give me the # of records..

>
>So, you only have to worry about the size of the three files.

Yeah.. This is what I've been thinking..
"Now to him who is able to do immeasurably more than all we ask or imagine, according to his power that is at work within us, Ephesians 3:20
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform