Home DADE

FieldAlias action as Fieldname

edited August 2006 in DADE
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

Comments

  • edited August 2006
    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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited September 2006
    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

  • edited September 2006
    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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
This discussion has been closed.