Baseplate Posted August 22, 2013 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
fmj02 Posted August 22, 2013 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.
Baseplate Posted August 23, 2013 Author 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.
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