LibreOffice Base - Group 16

SQL View/Update Constraints

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.

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.

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)