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.5   10.0   10.1   10.2   10.3   10.4   10.5   11.0   11.1   11.2    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.InsertOrUpdateRecord4
Inserts or updates a record in a table in one line.
All
11.2
FM.InsertOrUpdateRecord5
Inserts or updates a record in a table in one line.
All
11.2
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.Avg
Calculates average value in a record set.
All
9.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.JSONColumn
Returns a column as JSON array.
All
10.5
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.Max
Queries max value in a record set.
All
9.1
FM.SQL.Min
Queries min value in a record set.
All
9.1
FM.SQL.Release
Releases memory used for the SQL result.
All
5.1
FM.SQL.ReleaseAll
Release all FMSQL objects.
All
10.5
FM.SQL.RowCount
Queries number of rows in the result.
All
5.1
FM.SQL.Sum
Calculates sum value in a record set.
All
9.1
FM.SQL.Text
Queries text of SQL result.
All
7.0
FM.SQL.XMLRecord
Returns a row as XML object.
All
10.3
FM.SQL.XMLRecords
Returns rows as XML.
All
10.3
FM.SetSQLBatchMode
Sets turbo level for sending SQL in chunks.
All
6.4
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

58 functions.

Blog Entries

FileMaker Magazin

Feedback: Report problem or ask question.




Links
MBS Xojo blog

Start Chat