Script Steps

Script Step	CNS Query Add Field
Script Step	CNS Query Add Record
Script Step	CNS Query Add Table
Script Step	CNS Query Execute SQL
Script Step	CNS Query Field Exists
Script Step	CNS Query Find Records
Script Step	CNS Query Get Base Table Names
Script Step	CNS Query Get Configure Option
Script Step	CNS Query Get FM Error Text
Script Step	CNS Query Get Field IDs
Script Step	CNS Query Get Field Names
Script Step	CNS Query Get Field Types
Script Step	CNS Query Get Field Value By Find
Script Step	CNS Query Get Field Value By Record ID
Script Step	CNS Query Get Layout Field Names
Script Step	CNS Query Get Layout IDs
Script Step	CNS Query Get Layout Names
Script Step	CNS Query Get Record Data
Script Step	CNS Query Get Record Data Column Count
Script Step	CNS Query Get Record Data Row Count
Script Step	CNS Query Get Table Occurrence IDs
Script Step	CNS Query Get Table Occurrence Names
Script Step	CNS Query Layout Exists
Script Step	CNS Query Register
Script Step	CNS Query Remove Field
Script Step	CNS Query Remove Record By Find
Script Step	CNS Query Remove Record By ID
Script Step	CNS Query Remove Table
Script Step	CNS Query Set Configure Option
Script Step	CNS Query Set Field Value By Find
Script Step	CNS Query Set Field Value By Record ID
Script Step	CNS Query Show Configure Dialog
Script Step	CNS Query Table Occurrence Exists
Script Step	CNS Query Update Record By Find
Script Step	CNS Query Update Record By ID
Script Step	CNS Query Version

CNS Query Execute SQL

Name	CNS Query Execute SQL
Description	Executes an SQL statement, with optional SQL variables. You can also optionally specify a separate open file and define whether to return the result as Text, JSON, or to be retrieved with the GetRecordData function.
Format	CNS Query Execute SQL ( Select entire contents ; SQL Parameter 3 ; SQL Parameter 4 ; SQL Parameter 5 ; Target ; File Name ; SQL ; Return As ; Field Separator ; Record Separator ; SQL Parameter 1 ; SQL Parameter 2 )
Required Parameters	SQL The SQL to send to FileMaker. Return As Choose “Text”, “JSON”, or “RecordData” to determine how you want the result returned to you. If you choose “RecordData”, this function will return a blank response when successful and you can use the CNS Query Get Record Data script step to retrieve any data.
Optional Parameters	Select entire contents If checked, the target field or variable will be replaced by the result of this script step. SQL Parameter 3 Extra parameter corresponding to any ?’s in your SQL query. SQL Parameter 4 Extra parameter corresponding to any ?’s in your SQL query. SQL Parameter 5 Extra parameter corresponding to any ?’s in your SQL query. Target Specify the field or variable to receive the file path. File Name The database file name. Field Separator When UseRecordData is False, and if the result contains the values from more than one field, specify what to insert between those values. [This can be more than one character; Default is a comma.] Record Separator When UseRecordData is False, and if the result contains the values from more than one record, specify what to insert between those records. [This can be more than one character; Default is a return.] SQL Parameter 1 Extra parameter corresponding to any ?’s in your SQL query. SQL Parameter 2 Extra parameter corresponding to any ?’s in your SQL query.