I have a client who wants to use an underscore in the alias name - something like Home_Country but when the query is run the underscore is stripped out. I understand that the underscore is used in keywords and that may be the reason. Is there an escape character that can be used to preserve the underscore?
Thanks!
Unfortunately, the need for
Unfortunately, the need for special characters in an Alias name was probably overlooked when we implemented the ability to add Alias names. The query itself actually keeps the underscores, but the grid the that displays the results removes them from all column headers on purpose and there's no way around it (the code: headerText.Replace('_', ' ')). It seems like it should only remove underscores from the headers without an alias defined (if it needs to remove them at all). I think this would make a great request for enhancement (RSE) with tech support.
Courtney Robertson
Software Developer II
Advanced Solutions International