90 likes | 583 Views
Types of validation. AnnMarie Minter. Types of validation. Range check Length check Look up check Presence check Format check. Range check. Checks that a value is in a given range. Length Check. Checks that a value has a certain maximum length. Look up check.
E N D
Types of validation AnnMarie Minter
Types of validation • Range check • Length check • Look up check • Presence check • Format check
Range check Checks that a value is in a given range
Length Check Checks that a value has a certain maximum length
Look up check Checks that data takes one of a set of predefined values
Presence check Ensures that data is entered into a field
Format check 0 A number 0-9 must be entered # A number 0-9 is optional L A letter between a-z must be entered ? A letter between a-z is optional A A letter or a digit must be entered a A letter or a digit is optional & Any character (or symbol) can be entered > Convert everything that follows to upper case < Convert everything that follows to lower case We combine the input mask codes, e.g.: “L????” or “0&00” or “Aaaa&&&”.