HomeActive Query Builderhi how to get the datatype of the field of the selected table

hi how to get the datatype of the field of the selected table


Hi I need to get the query data type that each selected field of my table, because with this instruction I have the field

aqb.QueryStatistics.UsedColumns.Items [0]. MetadataField.Name.ToString ();
key result is

I have my table example
A
varchar key [6]

and I need to get the varchar [6]
miguel | email
September 1 2011, 02:21 PM
Try to use MetadataField.FieldTypeName
Sergey Smagin | email
16 hours, 48 mins since original post
ok tnk and how to get the alias field example


as if I have select group gpo, group as gp from table
I need to get the alias of these two fields and select the field of
miguel | email
6 days, 22 hours since original post
Use following code:

UnionSubQuery usq = queryBuilder1.ActiveSubQuery.ActiveUnionSubquery;

CriteriaList criteriaList = usq.CriteriaList;

for (int i = 0; i < criteriaList.Count; i++)
{
CriteriaItem ci = criteriaList[i];
string alias = ci.Alias;
bool selected = ci.Select;
}
Eugene Starkov | email
1 week, 6 days since original post
This topic is closed