Add new column

Adding a new column ALTER TABLE tbl_status ADD COLUMN status_default TEXT; This will cause an error if the column already exists.  To check if a column already exists first you can use: PRAGMA table_info(tbl_status); which will return a table listing the columns of the table.  However many people use the built in PRAGMA user_version) to store […]

Read More

DateTime

https://www.sqlite.org/lang_datefunc.html Reading DateTime In Select Statements You need to specify you want the value returning in a DateTime format or you can just get the year portion returned! Command1->CommandText = "SELECT datetime(LogDateTime) as LogDateTime, SomeOtherColumnName FROM MyTable";   Faster Searches Based On Date One nice and simple solution is to store dates as an intiger using this […]

Read More