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.
Where would this go
-
- Posts: 2
- Joined: Tue Aug 23, 2016 8:44 pm
Where would this go
I'm creating a user id based on the first three letters of the first and last name and the last 3 characters of the ID field -- Select UPPER (concat(left(userlastname,3), left(userfirstname,3), right(user_id,3))) as 'Gateway_User_Id' from user -- I've tried in vain to place it correctly to create and fillin the appropriate field -- when I show the form nothing happens or I get a SQL error stating the query is incorrect -- the query executes fine in when run in the database -- I'm new to nuBuilder so don't slam me to hard --