Difference between revisions of "Data Validation"

From Lianjapedia
Jump to: navigation, search
(Validation Rules)
(Validation Rules)
Line 4: Line 4:
  
 
Validation rules prevent bad data being saved in a table.
 
Validation rules prevent bad data being saved in a table.
 +
 +
Validating data in Lianja allows you to check data whilst it is being entered by the database user and will enable you to not save the data if it breaks any validation rules or routines.
 +
 +
It is easy for an end user to make a mistake when they are entering data or even to leave out important details that must be entered, so we need to check this data when it is being entered into the database.
 +
 +
Allowing invalid data to be entered into the database ensures that the database and the data available will become less valuable and harder for the user to use.
  
 
==Validation Rules in the UI==
 
==Validation Rules in the UI==

Revision as of 08:49, 4 December 2017

Under Construction

Validation Rules

Validation rules prevent bad data being saved in a table.

Validating data in Lianja allows you to check data whilst it is being entered by the database user and will enable you to not save the data if it breaks any validation rules or routines.

It is easy for an end user to make a mistake when they are entering data or even to leave out important details that must be entered, so we need to check this data when it is being entered into the database.

Allowing invalid data to be entered into the database ensures that the database and the data available will become less valuable and harder for the user to use.

Validation Rules in the UI

Data Types

Input masks

Validation Expressions

Validation in Custom Delegates

Required input

Cross Table Lookups

Validation Rules for Fields

Validation Rules for Tables