Field SQL Alias in Field select dropdown
Hello
Would it be possible to have Field SQL Alias in Field select dropdown instead of the fieldname ? There are so many ambiguous names that our staff are having difficultly knowing which is which. Sometimes there are 3 tables in a join with the same field name. The fieldname SQL alias is listed when adding to the report, so that's handy.
Would it be possible to have Field SQL Alias in Field select dropdown instead of the fieldname ? There are so many ambiguous names that our staff are having difficultly knowing which is which. Sometimes there are 3 tables in a join with the same field name. The fieldname SQL alias is listed when adding to the report, so that's handy.
Comments
Does this request make sense?
Andy
Sorry for the delayed response.
I am unclear about which dropdown you are referring to (this message is posted to the RAP category which does not have any dropdowns).
Note that DADE only uses field aliases when building a SQL statement. The field alias is also use for the Data Tree in the designer and in RAP as well as the drop down when placing a data-aware component on a report.
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com