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