Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is it the table close to its bordering ?
Message
From
08/02/2005 12:45:38
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
08/02/2005 10:51:00
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00984751
Message ID:
00984779
Views:
29
This message has been marked as the solution to the initial question of the thread.
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.

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.

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

>Greetings,
>
>V.F.P. tables subject:
>
>Does anyone would like to share with us, a UDF to measure where we are positioned face to any table's limit ?
>
>I mean we have limits on: # of records, # of bytes, # of bytes for CDX, FPT..
>
>This is a subject that affect us all.. And, I was wondering something as:
>
>
>lnNumber_of_regs_to_insert = lnNumber_to_process
>if  my_rules_tier.limit_of_my_table("c:\folder\mytable.dbf", lnNumber_of_regs_to_insert) > 90 && reach more than 90 percent
>    * warn user
>endif
>* perform task
>
>
>TIA
>
>Claudio
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform