RE: Support for User Defined Fields

[Nathan Andelin <nandelin@xxxxxxxxxxxx>]

> rob@xxxxxxxxx wrote:
> When the user activates one of these fields will the appropriate
> check constraints, and/or referential constraints, now take effect?
> ie:  Must  be a valid date that is less than 125 years in the past
> or some such thing?

Good questions.  I didn't envision defining constraints with DDS or SQL, 
or generating triggers, but it seems that some level of data validation 
needs to be available.  I do envision enabling users to define drop-down 
and popup selection lists, where list values are defined in other 
tables.

I did envision a flag in the field definition to indicate whether a 
value is required (non blank) or not.  I was thinking about enabling 
range validation for numeric fields, but hadn't considered date range 
validation.

Thanks, for the suggestion.

Nathan.