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?
Welcome to the nuBuilder forums!
Please register and login to view forums and other content only available to registered users.
Please register and login to view forums and other content only available to registered users.
Space being stripped.
-
- Site Admin
- Posts: 2781
- Joined: Mon Jun 15, 2009 2:23 am
- nuBuilder Version: 4.5
- Been thanked: 1 time
Re: Space being stripped.
russhart,
Try making the column wider, it might be going on to a new line.
Steven
Try making the column wider, it might be going on to a new line.
Steven
-
- Posts: 2
- Joined: Mon May 02, 2016 12:19 am
Re: Space being stripped.
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.
Thanks for the reply.