How do I use an ENUM field type?

AndrewW · Unread post by **AndrewW** » Thu Oct 04, 2012 8:16 am

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

Unread post by **admin** » Thu Oct 04, 2012 8:58 am

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

EcoReality · Unread post by **EcoReality** » Fri Feb 17, 2017 2:04 am

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!

Unread post by **admin** » Sat Feb 25, 2017 8:59 pm

Jan,

What version are you using?

Steven

EcoReality · Unread post by **EcoReality** » Tue Feb 28, 2017 4:34 am

admin wrote:What version are you using?

nuBuilder3

Jan

Unread post by **admin** » Sun Mar 19, 2017 5:18 pm

Jan,

Sorry but this question is in the wrong spot.

Steven

nuBuilder Forum

How do I use an ENUM field type?

How do I use an ENUM field type?

Re: How do I use an ENUM field type?

Re: How do I use an ENUM field type?

Re: How do I use an ENUM field type?

Re: How do I use an ENUM field type?

Re: How do I use an ENUM field type?