> A system sp that parses domain definitions
> returning a dataset with those values for
> a given domain would be very worthful.
> It could be very interesting for you,
> (being able to create comboboxes from limited-values
> domains for a data entry form on-the-fly).

Given that a "domain definition" can hold pretty much anything,
this would be nasty to create.

Feel free to parse your domain-check constraint at the client
side to fill your combobox.

>
>
> On Fri, 8 Apr 2005 20:21:52 +0200, Martijn Tonies wrote:
>
> >
> >> Thanks but I guess it wasn't to clear what I need. Say I have a field
> >named OBSTRUCTIONS and the valid entries are "TREES" "TOWER" "BUILDING"
> >"NONE" and "OTHER". I can set constraints to limit input to this field to
> >these values OK but I also need to have a drop down list for the user to
> >choose from. Otherwise how would he know what to enter. Also I don't want
> >the user to type the entry, just pick it from a list. This is pretty
> >important to my app and seems like something the a db system would

support.

> >
> >Right. Now I understand. And how do you expect a generic database engine

to

> >populate a Windows combobox then?
> >
> >So, the answer would be: you need to do that yourself.
> >
> >Just code the entries in the combobox.
> >
> > Like I said in my earlier message Firebird does exactly what I need with
> >the drop down list of available domains. Thanks again. Bob Ritter

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com