Product Logo

CNS Query

Query your databases without relationships.

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

CNS Query Get Field IDs

NameCNS Query Get Field IDs
Description

Returns either the ID of a specific field or a list of “FieldName=FieldID” pairs for all fields in a table.

FormatCNS Query Get Field IDs