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 Update Record By Find

Name	CNS Query Update Record By Find
Description	Updates one or more records based on find criteria.
Format	CNS Query Update Record By Find ( File Name ; Table Name ; Field Values ; Find Criteria ; Case Sensitive ; Update All Matches )
Required Parameters	Field Values A return- or paragraph mark-separated list of “FieldName=FieldValue” pairs used to update the record. [Use “” to indicate returns in the field values.] Find Criteria A return- or paragraph mark-separated list of “FieldName=FieldValue” pairs used to find the record. [Use "” to separate multiple values for a single field.] Case Sensitive If True, the plug-in will preserve the case in the find criteria. [Default is False.] Update All Matches If True, the plug-in will update all records that match the find criteria. [Default is False, which only updates the first record.]
Optional Parameters	File Name The database file name. Table Name The name of the table occurrence that contains the record to update. [Specify “” to use the current layout Table Occurrence.]