SQLite: No such table (Code1)

Discuss
#1

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.

1
1.png923×460 25.7 KB
2
2.png857×460 25.8 KB

#2

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);

1 Like
#3