Topics   All   Mac OS X (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server   Client   Old   Guides   Examples
New in version: 7.2   7.3   7.4   7.5   8.0   8.1   8.2   8.3   8.4   8.5    Statistic  


Queries statistics on a table.

Component Version macOS Windows Server FileMaker Cloud FileMaker iOS SDK
FM 8.2 Yes Yes Yes Yes Yes
MBS( "FM.TableStatistics"; FileName; TableName )   More


Parameter Description Example value
FileName The target database name.
Can be empty to not limit query to one database.
TableName The name of the table to check. "Contacts"


Returns OK or error.


Queries statistics on a table.
The plugin will walk over all records and count fields with various data types and how many empty fields are there.
We sum up the length of all text in text fields as well as the text content of all fields.
We sum up the size of all internal containers, so ContainerByteSize + AllTextLengths*2 plus some metadata is the size of the database file.
For internal containers we also count the streams inside, so you know how many JPEGs and other file types are in the table.



Check statistics:

MBS( "FM.TableStatistics"; "Contacts.fmp12"; "Contacts" )

Created 26th April 2018, last changed 27th April 2018

FM.StopScriptIdle   -   FM.UpdateRecord

Feedback: Report problem or ask question.

MBS Xojo Plugins