Database information

HenningThHenningTh Member Posts: 59
Hi all
I am about to make Database info ready for WebService - i.e. making a remote request for NavStatus.
Most info's are already available but when trying to find out how much space has been used I fail.
Table Information do not give correct result when you add up all the KB's used and I cannot finde anywhere in tables the correct information.
Can anybody help here?

I know the solution for SQL, but its the native base that troubles.

Thanks in advance :-k

Comments

  • GRIZZLYGRIZZLY Member Posts: 127
    Have you tried to mine data from Table Information or Database File virtual tables.
    2 suggestions:
    1. Calculate Summ of field Size (Kb) for Table Information table
    2. Or get Size (Kb) from Database File table
    Sincerely yours, GRIZZLY
    Follow my blog at http://x-dynamics.blogspot.com
  • HenningThHenningTh Member Posts: 59
    GRIZZLY wrote:
    Have you tried to mine data from Table Information or Database File virtual tables.
    2 suggestions:
    1. Calculate Summ of field Size (Kb) for Table Information table
    2. Or get Size (Kb) from Database File table

    Thanks for reply, but sorry to say Grizzly that it does not give the correct info.
    The sum of FieldSize(Kb) in "Table information" does not correspond to the info as seen in File/databaseinfo.
    "Database file" gives you the total size of the database and this info is of no use unless you can tell´how much space have been used.
Sign In or Register to comment.