Table

Top Previous Topic Next Topic  Print this topic

Overview: When the output format is Database Output, tables are required to be defined (either when creating a new table or updating an existing one), in order for the SQL Query to know where to apply the changes. These tables must be defined using the Table dialog.

 

Accessing: There are multiple methods to access this dialog:

right clicking on a Schema and selecting the New Table option.
right clicking on an already user defined table and selecting the Properties option.

 

table_dlg

 

Name - the table's name
Command Type - the user can either insert new entries in the defined table, or update the existing ones
PK - if checked, specifies is the column is the table's Primary Key
Name - specifies the table's name
Type - specifies if the data entered for this column is Text, Numeric or Date.
Add - adds a new column to the existing ones