Page 1 of 1

TOraQuery - Get actual field name from field alias

Posted: Tue 29 Sep 2009 11:32
by dados
Hi,

Is there any way to get actual field name from a select statement?

like:
select name as customer_name from customers
or
select name customer_name from customers

I've tried using this:
TDBAccessUtils.GetIRecordSet(vDataSet).Fields.Items[0].ActualName;
it returns customer_name
and
TDBAccessUtils.GetIRecordSet(vDataSet).Fields.Items[0].Name;
also return customer_name

Any ideas?

Reg, Arni Thor

Resolved :)

Posted: Tue 29 Sep 2009 11:53
by dados
I found, later in the forum this solution:

vDataSet.GetFieldDesc('Field1').ActualName;