FieldAlias action as Fieldname

rbuser

Hello,

RB 7.02 and Delphi 7.0.

I've these table and when I go through the loop its not loading the field
alias its using the field Name. What could be the reason?

f : tdaField
for i := 0 to SQL.SelectFieldCount -1 do begin
f := SQL.SelectFields[ i];
end;
This f is showing me the FieldAlias same as FieldName but my table has the
different fieldName and fieldAlias.

Please help.

Thanks
-Bhoj

nicocizik

Hi Bhoj,

The FieldAlias is either obtained from the DataDictionary, or (if you are
not using the DataDictionary) from the FieldName. If you need the
FieldAlias to display something different than the FieldName, you will need
to implement the DataDictionary for your project.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Thanks Nick,
I'm using Data Dictionay to and my TMDDField table has field name and field
alias different but the moment it goes to SQL.SelectFields[ i];
It loads the and I said f.FieldAlias it is same as fieldName but in
tmddtable is it different. I don't know what's happening. We have released
out product like two years back and one noticed it at all and I was just
debugging something else and found it and said opps.... but couldn't able to
fix it yet.

Thank you for your time
-Bhoj

nicocizik

Hi Bhoj,

Where in your app are you calling SQL.SelectFields? Perhaps you are calling
this too early for the field alias to be set. Does this happen for every
field?

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com