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.
March 20 2008, 12:01 PM
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.
14 hours, 42 mins since original post