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 Layout Field Names

NameCNS Query Get Layout Field Names
Description

Returns a list of field names from a layout.

FormatCNS Query Get Layout Field Names ( Select entire contents ; Target ; Layout Name )
Optional Parameters
Select entire contents

If checked, the target field or variable will be replaced by the result of this script step.

Target

Specify the field or variable to receive the file path.

Layout Name

The name of the layout that contains the fields. [Specify “” to use the current layout.]