Editing Field Aliases

Applies to LoadComplete 4.97, last modified on May 20, 2019

Use the Edit Field dialog to specify an alias for a database field. The dialog is called when you modify a query for a database variable in the SQL Designer.

Edit Field Dialog

The Table text box specifies the name and alias of a table or view, to which the desired field belongs. This text boxes is read-only.

The Field box specifies the field’s original name. This box is also read-only.

The Alias box specifies the alias to be used for the field in the query. Type the desired name into this box and press OK to apply the changes. Cancel will close the dialog discarding any editing.

Note: The alias should be unique. It should not coincide with other field aliases. Also, the alias should not coincide with SQL reserved words like From or Select.

The specified alias must conform to SQL rules used for the field names.

See Also

Database Variables
Designing SQL Queries

Highlight search results