Emerging Information Technologies - Examples
   Skip Navigation LinksETL Course Home > ETL Examples > Validation > Validation Skip Navigation Links
ETL Course Home
ETL ExamplesExpand ETL Examples
Skip Navigation Links.  

              Login  














Section User Information Validation
1 Name     Required field validator
(Following apply to all Validations!)
-Control to Validate 
-Reword the Error message
-Text (type '*' or something else / or leave it blank if you want the error message to be displayed here)
-Both text (if not left blank) and error messages appear when validation fails
2 Age (should be between 18 and 25)       Required field validator
and Range validator
(max, min)
-Data type (string, integer, double, date, currency)
3 Email

      Required field validator
and Regular expression validator
(choose validation expression - internet email address)
4 Ph Number

      Required field validator
-Regular expression validator (choose US ph number)
5
Choose a Number Less than or equal to  the value in this reference box
  Compare validator
-Control to compare
-Type(integer, string, double, date, currency)
-Operator (greater than, less than etc.)
6 Enter decimals / or numbers only    Compare validator
-Type (double etc.)
7 Enter a number greater than 25   Compare validator
-Operator (greater than)
-Value to compare (25)
-Type (Integer etc.)
8 Choose a Department


     Hint: Initial value=Select One
  Hint: Causes Validation is set to false for the Reset button


 
-Error messages appear in the validation summary area.
-In the validation summary properties - you can set the message box option to true
Copyright Gaurav Bansal (c) 2007