SQLite: Unable to prepare statement


I have this code:

[code]Dim ps As SQLitePreparedStatement = _
Prepare(“INSERT INTO tables (project_id, name, entityname, entitycollectionname) VALUES (?, ?, ?, ?)”)

ps.BindType(0, SQLitePreparedStatement.SQLITE_INTEGER)
ps.BindType(1, SQLitePreparedStatement.SQLITE_TEXT)
ps.BindType(2, SQLitePreparedStatement.SQLITE_TEXT)
ps.BindType(3, SQLitePreparedStatement.SQLITE_TEXT)

ps.Bind(0, P.ID)
ps.Bind(1, TableName)
ps.Bind(2, TableName)
ps.Bind(3, TableName + “Collection”)



And it shows the error message: Unable to prepare statement.
When I copy and paste the SQL in the database, it works just as expected.

Does anyone see what I’m clearly missing?

I was wrong, the code worked perfectly, I didn’t save the changes to the database… (the newly added tables etc.)