LibreOffice Base SQL: Update and Delete Records


While the INSERT statement is about creating records, the UPDATE statement is about changing data in an existing record. Therefore, unless you specify which record to change, the UPDATE will apply to all records. Continue reading


LibreOffice Base SQL: Inserting Data Records

In most cases you will never use SQL to insert data into Libreoffice Base tables as this is mostly done through forms. However, it helps to know how the SQL works for those occasions when you get error messages when trying to input data through a form, and there are also times when you just need a small table with a few records for selection in a form. Creating a form in the latter case might take more time than just entering the data through SQL. Today, I am going to show you the basics of inserting records into a table. Continue reading

LibreOffice Version Control

While working on a manuscript, it is a good idea to keep different versions of the document (1st draft, 2nd draft, 3rd draft, etc.) in case you need to go back to an earlier version of your work. Many times this is accomplished by saving the document under a new name. Another approach is using some kind of version control software that allows you to track changes. However, LibreOffice does have a basic version control system built in and contains all the versions in one file. Continue reading

Troubleshooting Christmas Mini-Lights

The Christmas season is upon us. Along with the season comes decorating. With decorating, you have 100’s of little mini Christmas lights. Christmas lights are great when they work, and sometimes troublesome when they don’t. You are likely to run into two different breeds of mini-lights. One that just goes dead causing the whole series of 50 bulbs to go dead, and the newer style that goes dead but allows the others to continue to glow. Continue reading

LibreOffice Base SQL: Altering Tables

So far, we have looked at the different data types and creating tables using SQL in LibreOffice Base with the default HSQLDB database management system. Sometimes when you create a table using SQL, you don’t always get it right the first time, so SQL allows you to alter, or change, the structure and layout of the table. Continue reading