Alias Property (Field)

Syntax

Field.Alias= string

Notes

Read/Write at run time. Unavailable at design time. Property applies to Field object.

Description

This property determines the alias of the field in the SQL statement, as in

SELECT …, field AS alias, … FROM …

By default, it returns the Alias name specified for a view field in Schema Designer. Setting this property at run time changes the alias used in generated SQL statements for all folder fields representing the same view field.

This property has a special meaning in DataSource mode, if FilterMode=True. In that case, it determines the name by which the field appears in the Filter condition (in ClauseWhere).