Difference between revisions of "Data Validation"
Barrymavin (Talk | contribs) (→Validation Rules in the UI) |
Barrymavin (Talk | contribs) (→Data Integrity through Validation Rules) |
||
Line 1: | Line 1: | ||
''Under Construction'' | ''Under Construction'' | ||
− | == | + | ==Validation Rules== |
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 | + | 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. |
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. | 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. |
Revision as of 21:07, 4 December 2017
Under Construction
Contents
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.
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.
In an business application its not only users who perform CRUD (Create Read Update Delete) operations on data but also external processes such as loading tariffs, prices etc into tables periodically in batch.
There must be protections in place to prevent data corruption and invalid data being stored in a database.
This is where validation rules come into play.