Hello
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”)
ps.SQLExecute
MsgBox(App.db.ErrorMessage)[/code]
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?
Thanks!