Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Quickest way of finding out byte size of a table
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00950352
Message ID:
00950354
Views:
12
>Hi! What's the quickest way of finding out the byte size of table?
>
>TIA


I am not sure that is the quickest way:

1. use ADIR() function
  cTable = ADIR(aTable, full_path_to_table+"TABLE.DBF")
  IF cTable > 0
    ? aTable[1, 2] && File Size
  ENDIF
2. FILETOSTR() function
    ? LEN(STRTOFILE(full_path_to_table+"TABLE.DBF")) && File Size
But keep in mind that If You have some uncommited changes the size migth be different
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Reply
Map
View

Click here to load this message in the networking platform