Monkeybread Software - MBS FileMaker Plugin: Component: FMSQL

Components	All	New	MacOS		Windows		Linux		iOS
Examples	Mac & Win		Server	Client	Guides	Statistic	FMM	Blog	Deprecated	Old

Component: FMSQL

SQL inside Claris FileMaker databases

This functions help you execute SQL within the Claris FileMaker database on client and server.

If you look for SQL functions to other databases (like MySQL), please check our SQL functions and for Mongo databases the MongoDB functions.

Version	macOS	Windows	Linux	Server	iOS SDK
1.2 / 11.2	✅ Yes	✅ Yes	✅ 97%	✅ 98%	✅ 97%

Item	Details	Server
Dictionary.AddSQLRecord Adds values from a record to dictionary via SQL.	All 7.4	✅ Server
Dictionary.AddSQLRecords Adds values from a record to dictionary via SQL.	All 7.4	✅ Server
FM.CompareTables Compare two tables.	All 9.3	✅ Server
FM.DeleteRecord Deletes an existing record in a table in one line.	All 6.0	✅ Server
FM.DeleteRecords Deletes existing records in a table in one line.	All 6.0	✅ Server
FM.ExecuteFileSQL Execute the SQL Statement against a FileMaker database.	All 3.5	✅ Server
FM.ExecuteFileSQLOnIdle Executes a SQL command at idle time.	All 6.5	✅ Server
FM.ExecuteSQL Deprecated Execute the SQL Statement against the current FileMaker File.	All 1.2	✅ Server
FM.ExecuteSQL.LastError Queries the last error code from an SQL call	All 1.2	✅ Server
FM.ExecuteSQL.LastErrorMessage Queries the last error message from an SQL call	All 3.0	✅ Server
FM.ExecuteSQL.LastSQL Queries last SQL command.	All 7.4	✅ Server
FM.ExecuteSQLOnIdle Deprecated This is similar to FM.ExecuteSQL, except that it waits until idle to execute.	Mac/Win 1.2	✅ Server
FM.GetSQLBatchMode Queries turbo level for sending SQL in chunks.	All 6.4	✅ Server
FM.InsertOrUpdateRecord Inserts or updates a record in a table in one line.	All 6.0	✅ Server
FM.InsertOrUpdateRecord2 Inserts or updates a record in a table in one line.	All 6.1	✅ Server
FM.InsertOrUpdateRecord3 Inserts or updates a record in a table in one line.	All 6.1	✅ Server
FM.InsertOrUpdateRecord4 Inserts or updates a record in a table in one line.	All 11.2	✅ Server
FM.InsertOrUpdateRecord5 Inserts or updates a record in a table in one line.	All 11.2	✅ Server
FM.InsertOrUpdateRecordQuery Insert or updates a lot of records queried from a database.	All 8.4	✅ Server
FM.InsertRecord Inserts a new record in a table in one line.	All 5.1	✅ Server
FM.InsertRecordCSV Inserts records based on CSV text.	All 7.4	✅ Server
FM.InsertRecordQuery Inserts a lot of records queried from a database.	All 5.1	✅ Server
FM.InsertRecordQueryIgnoreDuplicates Inserts a lot of records queried from a database.	All 6.0	✅ Server
FM.InsertRecordTSV Inserts records based on tab/return separated text.	All 5.3	✅ Server
FM.InsertSetUpdateProgressDialog Enable updating progress bar.	Mac/Win 6.2	❌ Server
FM.NULL Returns a null value.	All 5.1	✅ Server
FM.QueryBaseTableNames Queries the base table names of all files currently open.	All 3.1	✅ Server
FM.QueryFieldsForBaseTableName Queries the field names of all fields in the given table.	All 3.1	✅ Server
FM.QueryFieldsForTableName Queries the field names of all fields in the given table.	All 3.1	✅ Server
FM.QueryTableNames Queries the table names of all files currently open.	All 3.1	✅ Server
FM.SQL.Avg Calculates average value in a record set.	All 9.1	✅ Server
FM.SQL.CSV Queries text of SQL result for CSV export.	All 7.0	✅ Server
FM.SQL.Execute Execute the SQL Statement against a FileMaker database.	All 5.1	✅ Server
FM.SQL.Field Queries field value for given position in result.	All 5.1	✅ Server
FM.SQL.FieldCount Queries number of fields.	All 5.1	✅ Server
FM.SQL.FieldType Queries field type for given position in result.	All 5.1	✅ Server
FM.SQL.InsertRecords Inserts records in FileMaker database from records in memory.	All 6.4	✅ Server
FM.SQL.InsertRecordsToSQL Inserts records in SQL database from records in memory.	All 6.4	✅ Server
FM.SQL.JSONColumn Returns a column as JSON array.	All 10.5	✅ Server
FM.SQL.JSONRecord Returns a row as JSON object.	All 8.1	✅ Server
FM.SQL.JSONRecords Returns rows as JSON array.	All 8.1	✅ Server
FM.SQL.Max Queries max value in a record set.	All 9.1	✅ Server
FM.SQL.Min Queries min value in a record set.	All 9.1	✅ Server
FM.SQL.Release Releases memory used for the SQL result.	All 5.1	✅ Server
FM.SQL.ReleaseAll Release all FMSQL objects.	All 10.5	✅ Server
FM.SQL.RowCount Queries number of rows in the result.	All 5.1	✅ Server
FM.SQL.Sum Calculates sum value in a record set.	All 9.1	✅ Server
FM.SQL.Text Queries text of SQL result.	All 7.0	✅ Server
FM.SQL.XMLRecord Returns a row as XML object.	All 10.3	✅ Server
FM.SQL.XMLRecords Returns rows as XML.	All 10.3	✅ Server
FM.SetSQLBatchMode Sets turbo level for sending SQL in chunks.	All 6.4	✅ Server
FM.TableStatistics Queries statistics on a table.	All 8.2	✅ Server
FM.UpdateRecord Update an existing record in a table in one line.	All 6.0	✅ Server
FM.UpdateRecord2 Updates existing records in a table in one line.	All 8.0	✅ Server
FM.UpdateRecord3 Updates existing records in a table in one line.	All 8.0	✅ Server
FM.UpdateRecords Updates existing records in a table in one line.	All 6.0	✅ Server
FM.UpdateRecords2 Updates existing records in a table in one line.	All 8.0	✅ Server
FM.UpdateRecords3 Updates existing records in a table in one line.	All 8.0	✅ Server

58 functions shown.

These functions require a license (71%).

Blog Entries

FileMaker Magazin

💬 Ask a question or report a problem