SQLite insert No such column error on android
I am not sure but you might need to have single quotes ''
around the strings inside VALUES
.Try:
String sql = "INSERT INTO food (name, sacharides, glycemia, category1) " + "VALUES ('" + nextLine[0] + "', '" + nextLine[1] + "', '" + nextLine[2]+ "', '" + nextLine[3] +"' )";
In my case,
unfortunately table name is mismatched. :^)take a rest. and going on!