If you find these tutorials useful, Please consider making a donation.

TheFrugalComputerGuy.png
TheFrugalComputerLogo.png

LibreOffice Base - Group 16

SQL View/Update Constraints










Video 43 - Edit a Constraint

We look at a few queries that shows information about the tables and fields we created from the HSQL database . Then we update a CHECK CONSTRAINT.










Video 44 - Review of Relationships

We see the Default value does not work properly LibreOffice (v4.2.0.4) GUI screens, then we review how Update Cascade and Delete: Set to Default work.










Video 45 - More about Constraints

We want to change the Department ID and Group ID fields to not null (set entry required to Yes), but we have to get around the constraint (as well as an issue with LibreOffice 4.2.0.4 gui screens)