Subject | Re: [Firebird-general] Dropdown list for variable domain |
---|---|
Author | Milan Babuskov |
Post date | 2005-04-07T16:15:20Z |
brcr11 wrote:
this, and populate dropdown-list with it:
select f.rdb$field_name
from rdb$fields f
join rdb$types t on f.rdb$field_type=t.rdb$type
where t.rdb$field_name='RDB$FIELD_TYPE' order by 1;
HTH
--
Milan Babuskov
http://fbexport.sourceforge.net
http://www.flamerobin.org
> The "Domain" field in the form for defining table entries has a dropYou can read domain names from systems table RDB$FIELDS. Use a query like
> down list of the available domains including the "stock" and user
> defined domains. I need to supply a similar ability to my table update
> screens to produce a drop down of available valid entries for my table
> fields.
>
> I'll bet it's easy once you know how. Any assistance is greatly
> appreciated.
this, and populate dropdown-list with it:
select f.rdb$field_name
from rdb$fields f
join rdb$types t on f.rdb$field_type=t.rdb$type
where t.rdb$field_name='RDB$FIELD_TYPE' order by 1;
HTH
--
Milan Babuskov
http://fbexport.sourceforge.net
http://www.flamerobin.org