Drop-down, concatenation, whitespace
Posted: Thu Nov 02, 2023 4:11 pm
I have changed an input field to a dropdown. I am loading the dropdown from a database table.
I need to show more than one field in the list of values that the user selects from, so I have an expression in the "choice options field" propery:
Since SHNAME is fixed-length character, the ADDUSER values should align, and they do in Run SQL Statements.
But not in Genie.
Is there a way to keep the whitespace?
Thanks in advance.
Ted
I need to show more than one field in the list of values that the user selects from, so I have an expression in the "choice options field" propery:
Code: Select all
LTRIM(DIGITS(ORDNO), '0') CONCAT ' ' CONCAT SHNAME CONCAT ' ' CONCAT ADDUSER
But not in Genie.
Is there a way to keep the whitespace?
Thanks in advance.
Ted