Hi there
For some reason my sql commands include gooblygook when passed to my sql connection..
java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (near "update": syntax error)
How do I solve this issue, there is nothing wrong with my sql statements, they compute when ran externally however in my bj4 app, bam!!
For some reason my sql commands include gooblygook when passed to my sql connection..
java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (near "update": syntax error)
B4X:
Dim jSQL As SQL = SQLGet
'we have update statements, process them first.
'Dim sqlCommands As List
'sqlCommands.Initialize
jSQL.AddNonQueryToBatch("update iymanalysisset set aprvar = aprproj - apract",Null)
jSQL.AddNonQueryToBatch("update iymanalysisset set mayvar = mayproj - mayact", Null)
jSQL.AddNonQueryToBatch("update iymanalysisset set junvar = junproj - junact", Null)
jSQL.AddNonQueryToBatch("update iymanalysisset set julvar = julproj - julact", Null)
jSQL.AddNonQueryToBatch("update iymanalysisset set augvar = augproj - augact", Null)
jSQL.AddNonQueryToBatch("update iymanalysisset set sepvar = sepproj - sepact", Null)
jSQL.AddNonQueryToBatch("update iymanalysisset set octvar = octproj - octact", Null)
jSQL.AddNonQueryToBatch("update iymanalysisset set novvar = novproj - novact", Null)
jSQL.AddNonQueryToBatch("update iymanalysisset set decvar = decproj - decact", Null)
jSQL.AddNonQueryToBatch("update iymanalysisset set janvar = janproj - janact", Null)
jSQL.AddNonQueryToBatch("update iymanalysisset set febvar = febproj - febact", Null)
jSQL.AddNonQueryToBatch("update iymanalysisset set marvar = marproj - maract", Null)How do I solve this issue, there is nothing wrong with my sql statements, they compute when ran externally however in my bj4 app, bam!!