Monkeybread Software - MBS FileMaker Plugin: Component: FMSQL

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.2 9.3 9.4 9.5 10.0 10.1 10.2 10.3 10.4 10.5 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

Feedback: Report problem or ask question.