Page 1 of 1
Validations
Posted: Tue Apr 26, 2011 8:46 am
by manwant
How do I do Validation checks using open office Base ?
Re: Validations
Posted: Tue Apr 26, 2011 9:10 am
by r4zoli
Please add more info what you means under "validation check" in Base, the inserted value check on forms or any other meaning?
Re: Validations
Posted: Tue Apr 26, 2011 9:28 am
by Villeroy
"Validation" like cell validation in spreadsheets? The details depend on the database you are using. No, Base is not a database but the thing mentioned in the status bar is. In case of true relational database (such as HSQLDB, MySQL, PostgreSQL, Oracle) the whole database is nothing but a validation engine. You declare the field types, if they are allowed to be empty, if some field is related to another table's field and other constraints depending on the database in use.
The main difference to spreadsheets is: A database stores records (table rows) directly to disk, thus validation applies to whole records. If something is missing, invalid or inconsistent in respect to another table there is no way to store it.