Variables MD3
search

Detailed Domain Specs, Length MD3

(This also applies for sets. Then for Detailed domain specs read Details domain specification.)

For types Text Length and Number Length the allowed values are not specified by a set of predefined values, but by other limitations.

Type Text Length Min, Max and input mask

Basically type Text Length can contain arbitrary text. The number of characters of that text is determined by two borders: a Minimum and a Maximum.

Min: a number can be typed being 0 or greater. When an "empty set" value is not allowed, it better be 1 or greater.

Max: a positive number can be typed. It must be greater than or equal to Min.

With a Max of 30 or less checkbox Enable input mask becomes accessible. User can set it on to specify a mask, a "textual pattern" for the text value. For each position an input box comes available. A dropdown menu offers meta characters * # ? $ % @ to be entered. Each defines a subset of characters that the position can contain. Click the down-arrowhead and select one of the next:

  • Any character (*)
  • Any numeric character (#)
  • Any letter (?)
  • Any uppercase letter ($)
  • Any lower case letter (%)
  • Any non-numeric, non-alphabetic character (@)

Alternatively a literal character can be typed. Then on consultation only that specific character is allowed. Example: a Dutch bank account number has the mask NL##$$$$##########

Type Number Length From, To and number format

The Number Format applies to types Number List and Number Length. See item at the left.

A Number Length type can contain a number. The possible number values are limited by the Interval with input fields From and To. In each a number can be typed, negative, positive or 0. The value in To cannot be less than the value in From.

From is accompanied by checkbox Exclusive of starting point. To has checkbox Exclusive of end point. TO IMPLEMENT.

Suppose the limits are -1.1 and 7.05. If both checkboxes are off, a value is accepted on consultation of -1.1 or 7.05 or any value between these two. Set checkbox Exclusive of end point on. Now the value cannot be exactly 7.05. It can be a tiny bit less, for example 7.04999. Set checkbox Exclusive of starting point on. Now the value cannot be -1.1 but slightly more, say -1.10001

Alternatively in From can be typed -INF meaning minus-infinite. In To can be typed INF meaning infinite.