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 Field Exists

NameCNS Query Field Exists
Description

Checks for the existence of a field in a table.

FormatCNS Query Field Exists ( File Name ; Table Name ; Field Name )
Required Parameters
Field Name

The name of the field to search for.

Optional Parameters
File Name

The database file name.

Table Name

The name of the table occurrence to search for the field name.