Size of the Database

[Jean-Pierre LEROY]

Dear all,

I'm using SQLitening in remote mode; I would like to display the size of the Database on the client application.

Is-there an easy way to do that ?

Thanks,
Jean-Pierre

[Fred Meier]

I assume you want the size of the disk file.  You can use the page_count
and page_size Pragma's as follows:

   DiskFileSize = val(slSelStr("Pragma page_count")) * val(slSelStr("Pragma page_size"))

[Jean-Pierre LEROY]

It's work perfectly !

Thank you Fred,
Jean-Pierre