Instructions to alter column name and caption

For some Alfabet configurations, it is required or desirable to alter either the name of the column (which is not possible in the Show properties of an Alfabet query), or only the caption of the column (which is not possible in the SELECT clause of a native SQL query).

The Alfabet query language provides instructions that allow you to change only the name of the database column or only the caption of columns in a dataset.

The column name can be defined by adding the following instruction to the Alfabet query:

• RENAMECOLUMN("ColumnName","NewColumnName");

Use the following parameter(s):

The column caption can be defined by the following instruction:

• SETCOLUMNSHOWNAME("ColumnName","ColumnCaption");

Use the following parameter(s):