SortVisibility Column Name Issue
Posted: April 3rd, 2023, 5:17 pm
I recently encountered an error that said something like "character, hexadecimal value 0x0A, cannot be included in a name" and subsequently learned that the issue was with the SortVisibility values.
I encountered this again and figured out what is causing this.
I was using the wizard and adding result values from the inquire........the column names were not populating for me , so I was simply copying and pasting the column names. This inadvertently introduced a blank space at the end of the column name. Which was then propagated to the column name "SortVisibility". I am guessing that column name in "SortVisibility" is built by simply concatenating the inquire result column name with "DESC" or "ASC".
I wonder if this issue would be partially resolved if the result column name was trimmed when building the column name in "SortVisibility" ? I say partially, because I now realize that what I saw the other day was a space AND a x'0a' (LF).
Of course, I realize this is a non-issue if populating the result columns from the table columns..........but they are not populating for me at the moment.
I encountered this again and figured out what is causing this.
I was using the wizard and adding result values from the inquire........the column names were not populating for me , so I was simply copying and pasting the column names. This inadvertently introduced a blank space at the end of the column name. Which was then propagated to the column name "SortVisibility". I am guessing that column name in "SortVisibility" is built by simply concatenating the inquire result column name with "DESC" or "ASC".
I wonder if this issue would be partially resolved if the result column name was trimmed when building the column name in "SortVisibility" ? I say partially, because I now realize that what I saw the other day was a space AND a x'0a' (LF).
Of course, I realize this is a non-issue if populating the result columns from the table columns..........but they are not populating for me at the moment.