Space being stripped.

Space being stripped.

Postby russhart » Tue May 03, 2016 4:50 pm

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?
russhart
 
Posts: 2
Joined: Mon May 02, 2016 7:49 am

Re: Space being stripped.

Postby admin » Thu May 05, 2016 3:21 pm

russhart,

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

Steven
admin
Site Admin
 
Posts: 3406
Joined: Mon Jun 15, 2009 9:53 am
nuBuilder Version: 4.5

Re: Space being stripped.

Postby russhart » Thu May 05, 2016 4:49 pm

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.
russhart
 
Posts: 2
Joined: Mon May 02, 2016 7:49 am

Re: Space being stripped.

Postby admin » Thu May 12, 2016 4:08 pm

.
admin
Site Admin
 
Posts: 3406
Joined: Mon Jun 15, 2009 9:53 am
nuBuilder Version: 4.5


Return to Custom Code