Page 1 of 1
How do I use an ENUM field type?
Posted: Thu Oct 04, 2012 8:16 am
by AndrewW
I've got a database field type that I want as a fixed enumerated data tyep. such that possible values are locked in the database as simple single char answers. Is this supported with nuBuilder?
e.g. I've got a field as "enum('Y','N')" is there a way to show is as a drop-list on the form for choice selection?
Or am I forced to use lists to accomplish this?
-A
Re: How do I use an ENUM field type?
Posted: Thu Oct 04, 2012 8:58 am
by admin
Andrew,
Create a Dropdown Object with the following SQL..
Code: Select all
SELECT sli_option, sli_description FROM zzsys_list WHERE sli_name = 'answer'
(This uses records added via the List Button on the Setup Tab)
Steven
Re: How do I use an ENUM field type?
Posted: Fri Feb 17, 2017 2:04 am
by EcoReality
Steve, I don't understand how your code sucks the values out of an ENUM and puts them in a dropdown.
I don't have a table called `zzsys_list`. Do I need to load the example to see it?
Here is what I've been trying to do, but it doesn't seem to work.
Thanks for any help you can offer!
Re: How do I use an ENUM field type?
Posted: Sat Feb 25, 2017 8:59 pm
by admin
Jan,
What version are you using?
Steven
Re: How do I use an ENUM field type?
Posted: Tue Feb 28, 2017 4:34 am
by EcoReality
admin wrote:What version are you using?
nuBuilder3
Jan
Re: How do I use an ENUM field type?
Posted: Sun Mar 19, 2017 5:18 pm
by admin
Jan,
Sorry but this question is in the wrong spot.
Steven