Friends, I need help.
My system is with problem to the insert dates in SQLite. Always that done a requisition I receive the message: “SQLite: No such table (code 1)”.
The table is created in the inicialization and it is showed always when we asked.
From what I understand, in the initialization of the screen you are not creating a table. DROP is to delete tables, not to create them… then when you want to insert a data gives you the error that the table does not exist.
To create one you do so:
CREATE TABLE IF NOT EXISTS TableName (‘id’ INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, ‘SomeData’ TEXT, ‘SomeData2’ TEXT, ‘SomeData3’ DECIMAL);