Topics
All
MacOS
(Only)
Windows
(Only)
Linux
(Only, Not)
iOS
(Only, Not)
Components
Crossplatform Mac & Win
Server
Client
Old
Deprecated
Guides
Examples
Videos
New in version:
9.3
9.4
9.5
10.0
10.1
10.2
10.3
10.4
10.5
11.0
Statistic
FMM
Blog
Component: FMSQL
SQL inside FileMaker databases
This functions help you execute SQL within the FileMaker database on client and server.
If you look for SQL functions to other databases (like MySQL), please check our SQL functions.
Item | Details |
---|---|
Dictionary.AddSQLRecord Adds values from a record to dictionary via SQL. | All 7.4 |
Dictionary.AddSQLRecords Adds values from a record to dictionary via SQL. | All 7.4 |
FM.CompareTables Compare two tables. | All 9.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.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.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.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.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.SetSQLBatchMode Sets turbo level for sending SQL in chunks. | All 6.4 |
FM.UpdateRecord Update an existing record in a table in one line. | All 6.0 |
FM.UpdateRecords Updates existing records in a table in one line. | All 6.0 |
43 functions.
Blog Entries
- FileMaker SQL with Sum, Min, Max and Avg on results
- FileMaker Cloud Tipps & Tricks
- MBS FileMaker Plugin 6.1 für OS X/Windows
- MBS FileMaker Plug-in 6.1 for OS X/Windows
- MBS FileMaker Plugin 6.0 for OS X/Windows
Feedback: Report problem or ask question.

Links
MBS Xojo Plugins