Baseplate Posted August 22, 2013 Share Posted August 22, 2013 I'm having a problem with SQLite, here is the code now. executeSQLCreateTable("Groups", "GroupName STRING, FounderAccount STRING, Red STRING, Green STRING, Blue STRING, Type STRING, Members") executeSQLQuery("INSERT INTO Groups(GroupName, FounderAccount, Red, Green, Blue, Type, Members) VALUES(?, ?, ?, ?, ?, ?, ?)", tostring(group), tostring(account), tostring(red), tostring(green), tostring(blue), tostring(typeGroup), 1) My error is: Database query failed: table groups has no column named Red Link to comment
fmj02 Posted August 22, 2013 Share Posted August 22, 2013 STRING datatype doesn't exist in SQLite, consider using TEXT instead of it. http://www.sqlite.org/datatype3.html Best regards. Link to comment
Baseplate Posted August 23, 2013 Author Share Posted August 23, 2013 If that would really cause a problem, that would cause a problem to the others columns before Red column... Nevermind, solved it, I had to create another table for it. Link to comment
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now