SQLite: SQL error or missing database when inserting data into table

Question

I am trying to insert new data into a SQLite table.

• I know for sure that the insertion code is correct because I use it for different tables and it works fine.

• I know for sure that the database and the table are created and exist because I can see them in the SQLite Browser.

But something in the SQLite syntax of creation or insertion is wrong because I receive this exception:

SQL error or missing database

Here is my code:

CREATE TABLE IF NOT EXISTS Theory_answers ("questionID" INTEGER,"answerID" INTEGER,"answerText" TEXT, "isTrue" INTEGER);

INSERT INTO Theory_answers (questionID, answerID, answerText,isTrue) VALUES ("1","1",text,"0");

Answer 1

should this be....

VALUES ("1","1",text,"0") -> VALUES (1,1,'text',0)

Or

VALUES ("1","1","text","0") <-- if you need to double quote all values?

Looking at this link, it suggests inserts are done with single quote around the text and no quotes around the numbers...

sqlite> INSERT INTO Books(Id, Title, Author, ISBN) ...> VALUES(1, 'War and Peace', 'Leo Tolstoy', '978-0345472403');