Welcome to the nuBuilder forums!

Please register and login to view forums and other content only available to registered users.

Where would this go

mmuhlenkort2000
Posts: 2
Joined: Tue Aug 23, 2016 8:44 pm

Where would this go

Unread post by mmuhlenkort2000 »

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 -- :D
Post Reply