SQL Lite for android tip


Once a table has been created, you cannot simply add additional columns to the SQL which you used to create the table. You will get an error when you try to insert a new row. To fix this, you must create a new database or change the syntax to add a new column before trying to add a new row with the new columns you intend to create.