Page 1 of 1

Where would this go

Unread postPosted: Mon Aug 29, 2016 9:30 pm
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