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 Table Occurrence Names

NameCNS Query Get Table Occurrence Names
Description

Returns a list of table occurrence names from the database.

FormatCNS Query Get Table Occurrence Names ( Select entire contents ; Target ; File 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.

File Name

The database file name.