I cannot seem to determine “why” it cannot “prepare the statement”
The SQL has 9 fields, and 9 placeholders
the BindType as 9 entries
the Bind has 9 entries
the database is open, the table does exist
and notice I tried both syntax types for Execute, both give same error
Does anyone see what I am not seeing?
Note : I log all the exact values just prior to this statment, and they are all correct
ps=DB.prepare("INSERT INTO master ("+_
" object_id," + _
" level,"+_
" object_type,"+ _
" access_level,"+ _
" short_name,"+ _
" full_code,"+_
" abbr_code,"+_
" parent_id,"+_
" source_id) VALUES(?,?,?,?,?,?,?,?,?)")
//
ps.BindType(0, SQLitePreparedStatement.SQLITE_INTEGER)
ps.BindType(1, SQLitePreparedStatement.SQLITE_INTEGER)
ps.BindType(2, SQLitePreparedStatement.SQLITE_TEXT)
ps.BindType(3, SQLitePreparedStatement.SQLITE_TEXT)
ps.BindType(4, SQLitePreparedStatement.SQLITE_TEXT)
ps.BindType(5, SQLitePreparedStatement.SQLITE_TEXT)
ps.BindType(6, SQLitePreparedStatement.SQLITE_TEXT)
ps.BindType(7, SQLitePreparedStatement.SQLITE_INTEGER)
ps.BindType(8, SQLitePreparedStatement.SQLITE_INTEGER)
//
////ps.SQLExecute(object_id,level,tag,acl,outtokens(1),trim(code(i)),abbr_code,stack(0).right,source_id)
ps.Bind(0,object_id)
ps.Bind(1,level)
ps.Bind(2,tag)
ps.Bind(3,acl)
ps.Bind(4,outtokens(1))
ps.Bind(5,trim(code(i)))
ps.Bind(6,abbr_code)
ps.Bind(7,stack(0).right)
ps.Bind(8,source_id)
ps.SQLExecute