Topics   All   Mac OS X (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server (Not)   Client   Old   Guides   Examples
New in version: 6.0   6.1   6.2   6.3   6.4   6.5   7.0   7.1   7.2   7.3    Statistic  

Component: FM

Functions for FileMaker core functions like running scripts.

Name Description Mac/Win Version
FM.AllowFileDragDrop Installs fix for file drag and drop problem. Mac only 7.0
FM.Argument Query an argument passed to FileMaker from command line. All 5.1
FM.ArgumentCount Queries number of arguments. All 5.1
FM.CurrentScriptID Queries ID of current running FileMaker script. All 5.1
FM.CurrentScriptName Queries name of current script. All 5.1
FM.CurrentThreadID Queries current thread ID. All 5.1
FM.DataType Returns data type of argument. All 6.1
FM.DataViewerContent Looks for data viewer and copies visible table content. Mac only 6.3
FM.DeleteRecord Deletes an existing record in a table in one line. All 6.0
FM.DeleteRecords Deletes existing records in a table in one line. All 6.0
FM.DisableMouseWheel Disables use of mouse wheel on Windows. Win only 5.1
FM.DisableRuntimeEndWindow Disables end screen on runtime on Mac. Mac only 4.3
FM.EnableMouseWheel Enables use of mouse wheel on Windows. Win only 5.1
FM.Evaluate Similar to FileMaker's built in FM Evaluate All 1.3
FM.ExecuteFileSQL Execute the SQL Statement against a FileMaker database. All 3.5
FM.ExecuteFileSQLOnIdle This is similar to FM.ExecuteFileSQL, except that it waits until idle to execute. All 6.5
FM.ExecuteSQL Execute the SQL Statement against the current FileMaker File. All 1.2
FM.ExecuteSQL.LastError Queries the last error code from an SQL call All 1.2
FM.ExecuteSQL.LastErrorMessage Queries the last error message from an SQL call All 3.0
FM.ExecuteSQLOnIdle This is similar to FM.ExecuteSQL, except that it waits until idle to execute. Mac/Win 1.2
FM.GetSQLBatchMode Queries turbo level for sending SQL in chunks. All 6.4
FM.InsertOrUpdateRecord Inserts or updates a record in a table in one line. All 6.0
FM.InsertOrUpdateRecord2 Inserts or updates a record in a table in one line. All 6.1
FM.InsertOrUpdateRecord3 Inserts or updates a record in a table in one line. All 6.1
FM.InsertRecord Inserts a new record in a table in one line. All 5.1
FM.InsertRecordQuery Inserts a lot of records queried from a database. All 5.1
FM.InsertRecordQueryIgnoreDuplicates Inserts a lot of records queried from a database. All 6.0
FM.InsertRecordTSV Inserts records based on tab/return separated text. All 5.3
FM.InsertSetUpdateProgressDialog Enable updating progress bar. Mac/Win 6.2
FM.IsMainThread Checks if current thread is main thread. All 5.1
FM.MainThreadID Queries main thread ID. All 5.1
FM.MouseWheelScriptTrigger Installs a script trigger for mouse wheel. Win only 6.3
FM.NULL Returns a null value. All 5.1
FM.QueryBaseTableNames Queries the base table names of all tables currently open. All 3.1
FM.QueryFieldsForBaseTableName Queries the field names of all fields in the given table. All 3.1
FM.QueryFieldsForTableName Queries the field names of all fields in the given table. All 3.1
FM.QueryTableNames Queries the table names of all tables currently open. All 3.1
FM.RunDataDesignReport Performs a data design report automatically. Mac/Win 5.0
FM.RunScript Runs a script in any open FileMaker file. All 1.2
FM.RunScriptIdle Runs a script after idle period. All 3.3
FM.RunScriptLater Runs a script in any open FileMaker file. All 1.2
FM.SQL.CSV Queries text of SQL result for CSV export. All 7.0
FM.SQL.Execute Execute the SQL Statement against a FileMaker database. All 5.1
FM.SQL.Field Queries field value for given position in result. All 5.1
FM.SQL.FieldCount Queries number of fields. All 5.1
FM.SQL.FieldType Queries field type for given position in result. All 5.1
FM.SQL.InsertRecords Inserts records in FileMaker database from records in memory. All 6.4
FM.SQL.InsertRecordsToSQL Inserts records in SQL database from records in memory. All 6.4
FM.SQL.Release Releases memory used for the SQL result. All 5.1
FM.SQL.RowCount Queries number of rows in the result. All 5.1
FM.SQL.Text Queries text of SQL result. All 7.0
FM.ScriptIDForScriptName Queries the ID for script with given name. All 5.1
FM.ScriptNameForScriptID Queries script name for a script ID. All 5.1
FM.ScriptNames Queries list of script names in current file. All 5.1
FM.SetSQLBatchMode Sets turbo level for sending SQL in chunks. All 6.4
FM.SetThreadName Sets a new name for a thread. All 6.0
FM.StopScriptIdle Stops any idle timer. All 5.0
FM.UpdateRecord Update an existing record in a table in one line. All 6.0
FM.UpdateRecords Updates an existing records in a table in one line. All 6.0
FM.VariableClear Destroys a variable that was declared with FM.VariableSet. All 1.2
FM.VariableClearAll Clears all variables. All 5.2
FM.VariableExists Checks if a variable with that name exists. All 4.0
FM.VariableGet Retrieves the value of named variable that was declared using FM.VariableSet. All 1.2
FM.VariableList Returns list of all variables names and values. All 4.0
FM.VariableReset Resets the list of variables. All 4.0
FM.VariableSet Stores a named variable that can be retrieved later using FM.VariableGet. All 1.2

66 functions.

Feedback: Report problem or ask question.




Links
MBS FileMaker Plugins