HomeActive Query BuilderAlias names

Alias names

I know how to return a list of columns but many of my queries use columns with alias names. I want to return the column name of columns without alias and those that do have an alias I want to return the alias name.


John | email
March 20 2008, 12:01 PM
Dear John

The QueryStatistics.OutputColumns collection contains all that you need:
property Expression: WideString;
property ExpressionAlias: WideString;
property ColumnName: WideString;
property ObjectAlias: WideString;
property ObjectName: WideString;
property FieldType: TFieldType;

Also there is a link to the MetadataField object from the Metadata Container:
property MetadataField: TacMetadataField;

These properties are taken from the VCL Edition, but the similar ones are present in other editions as well.

Sergey Smagin
Sergey Smagin | email
14 hours, 42 mins since original post
This topic is closed