Page 1 of 1

Space being stripped.

Posted: Tue May 03, 2016 9:20 am
by russhart
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?

Re: Space being stripped.

Posted: Thu May 05, 2016 7:51 am
by admin
russhart,

Try making the column wider, it might be going on to a new line.

Steven

Re: Space being stripped.

Posted: Thu May 05, 2016 9:19 am
by russhart
Yes that was it. I had already made the column wider, but mustn't have rechecked it with just the space. As I said before, only just found this and still learning.
Thanks for the reply.

Re: Space being stripped.

Posted: Thu May 12, 2016 8:38 am
by admin
.