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.3   7.4   7.5   8.0   8.1   8.2   8.3   8.4   8.5   8.6    Statistic  

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.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.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

38 functions.

Feedback: Report problem or ask question.




Links
MBS FileMaker tutorial videos