FM.TableStatistics

Queries statistics on a table.

Parameters

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

Result

Returns JSON or error.

Description

Examples

Check statistics:

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

Loop over all tables to find their sizes:

Go to Layout [ “TableStatistics” (TableStatistics) ; Animation: None ]
#
Set Variable [ $FileName ; Value: Get(FileName) ]
Set Variable [ $TableNames ; Value: MBS( "FM.QueryBaseTableNames"; $fileName) ]
#
# loop counting up from 1 to $count
Set Variable [ $count ; Value: ValueCount($TableNames) ]
Set Variable [ $index ; Value: 1 ]
#
Loop [ Flush: Defer ]
    # your script steps here
    Set Variable [ $TableName ; Value: GetValue($tableNames; $index) ]
    Set Variable [ $JSON ; Value: MBS( "FM.TableStatistics"; $FileName; $TableName ) ]
    #
    New Record/Request
    Set Field [ TableStatistics::JSON ; $JSON ]
    Set Field [ TableStatistics::Name ; $TableName ]
    Commit Records/Requests [ With dialog: Off ]
    #
    # next
    Set Variable [ $index ; Value: $index + 1 ]
    Exit Loop If [ $index > $count ]
End Loop

See also

• FM.QueryBaseTableNames

Release notes

• Version 10.0
  • Changed FM.TableStatistics to ignore calculated and global fields.
• Version 9.0
  • Added TotalSize, CountZLIB, SizeZLIB, CountFORK and SizeFORK fields for FM.TableStatistics function.
• Version 8.2
  • Added FM.TableStatistics function.

Example Databases

• Utility functions/TableStatistic

Blog Entries

• MBS FileMaker Plugin, version 9.6pr1
• MBS FileMaker Plugin, version 8.6pr4
• MBS FileMaker Plugin 8.2 - More than 5200 Functions In One Plugin
• MBS FileMaker Plugin 8.2 - 5200 Funktionen in einem Plugin
• MBS FileMaker Plugin, version 8.2pr5

This function checks for a license.

Created 26th April 2018, last changed 21st March 2024

FM.StopScriptIdle - FM.TextWithDataType