Space being stripped.
Posted: Tue May 03, 2016 9:20 am
Hi, just found nuBuilder and like the program.
I am trying to get two fields to display as one in the browse form using CONCAT_WS(' ', field1, field2) in the 'Display' column so it displays as field1 field2. If i run it shown it displays field1 only. If I don't leave the space between the quotes I get field1field2. If I replace the space with an underscore the result I get is field1_field2 so somewhere in the code for the browse form it is stripping out that space. Using the same code on a form results in the correct display.
Can anyone help?
I am trying to get two fields to display as one in the browse form using CONCAT_WS(' ', field1, field2) in the 'Display' column so it displays as field1 field2. If i run it shown it displays field1 only. If I don't leave the space between the quotes I get field1field2. If I replace the space with an underscore the result I get is field1_field2 so somewhere in the code for the browse form it is stripping out that space. Using the same code on a form results in the correct display.
Can anyone help?