1
Download PDF
Transcript
208 Check numbers Indexed only, or unindexed only, or all numbers. Any numbers that occur in the field must match your specification. The way the specifications work is the same as for words. Indexed only, or unindexed only, or all dates. Check dates Indexed only, or unindexed only, or all terms. Disallow specific types Any dates that occur in the field must match your specification and conform to a specified format. The way the specifications work is the same as for words. The field must not contain terms of a specified type (word, number, or date). Unique terms Any indexed terms in the field must not already exist in the database’s index. This is useful for things like serial numbers or reference numbers. Non-unique terms Each indexed term in the field must already exist in the database’s index. If the field is meant to contain specific codes, this is a quick and informal way of checking for typing mistakes. Indexed only, or unindexed only, or all terms. Indexed only, or unindexed only, or all terms. Length of terms Each term entered in the field must be of a certain length, or its length must be within a specified range. Number of terms The field must contain a given number of terms, or the number of terms must fall within a range. You can specify separate limits for words, numbers, and dates. Length of field The field as a whole must be restricted to a certain length. Validators that change what is in a field This can look at indexed words only, or unindexed words only, or all words. Change case This validator changes the capitalisation of text: all capitals, all lower-case, or capital letters at the start of words, or capital letters at the start of sentences.
