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

NameCNS Query Add Field
Description

Adds a new field to an existing table.

FormatCNS Query Add Field ( File Name ; Table Name ; Field Name ; Field Type ; Global )
Required Parameters
Field Name

The name of the new field.

Field Type

The type of field to add.

Global

If True, the field will be added as a global field.

Optional Parameters
File Name

The database file name.

Table Name

The name of the table occurrence to receive the new field.