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  

Component: FM

Functions for FileMaker core functions like running scripts.

Item Details
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.Beep
Beeps.
Mac/Win
8.2
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.ExecuteSQL.LastSQL
Queries last SQL command.
All
7.4
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.InitMessageFilter
Initializes COM message filter.
Win only
8.3
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.InsertOrUpdateRecordQuery
Insert or updates a lot of records queried from a database.
All
8.4
FM.InsertRecord
Inserts a new record in a table in one line.
All
5.1
FM.InsertRecordCSV
Inserts records based on CSV text.
All
7.4
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.Loop
Universal function to run a loop with evaluate.
All
8.2
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.PatchNotificationProblem
Patched problem with Scroll Notifications.
Mac only
8.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.JSONRecord
Returns a row as JSON object.
All
8.1
FM.SQL.JSONRecords
Returns rows as JSON array.
All
8.1
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.TableStatistics
Queries statistics on a table.
All
8.2
FM.UpdateRecord
Update an existing record in a table in one line.
All
6.0
FM.UpdateRecord2
Updates existing records in a table in one line.
All
8.0
FM.UpdateRecord3
Updates existing records in a table in one line.
All
8.0
FM.UpdateRecords
Updates existing records in a table in one line.
All
6.0
FM.UpdateRecords2
Updates existing records in a table in one line.
All
8.0
FM.UpdateRecords3
Updates existing records in a table in one line.
All
8.0
FM.VariableAdd
Adds a value to a given value atomically.
All
8.3
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.VariableNames
Queries list of all variable names.
All
8.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

82 functions.

Feedback: Report problem or ask question.




Links
MBS Xojo Chart Plugins