Database Tip

In researching something else I ran across this tip that might be helpful.

If for some reason you need to insert a record into a database (at least for SQLite) but just want the default values , you don’t need to name all the fields (opps! columns :slight_smile: )…

INSERT INTO mytable DEFAULT VALUES

will produce a new record initialized with whatever defined default values were supplied in the CREATE TABLE statement and all you need to know it the table name itself…