All geek questions in one place

In SQLite there is no such column error on android

I have a problem inserting data from CSV. The CSV part works, but the insert returns the following error. This basically means that the column does not exist. Below is the code as well as the database code.

09-06 17:52:22.725: E/AndroidRuntime(19168): FATAL EXCEPTION: main 09-06 17:52:22.725: E/AndroidRuntime(19168): android.database.sqlite. SQLiteException: no such column: Ananas (code 1): , while compiling: INSERT INTO food (name, sacharides, glycemia, category1) VALUES (Ananas, 13, 45,1) 09-06 17:52:22.725: E/AndroidRuntime(19168): at android.database.sqlite.SQLiteConnection.nativePrepareStatement (Native Method)

Here is the code that fails.

  FoodDatabase myHelper = new FoodDatabase(getApplicationContext()); myDatabase = myHelper.getReadableDatabase(); String[] nextLine; try { while ((nextLine = reader.readNext()) != null) { // nextLine[] is an array of values from the line System.out.println(nextLine[0]+ " " + nextLine[1] +" "+ nextLine[2]); String sql = "INSERT INTO food (name, sacharides, glycemia, category1) " + "VALUES (" + nextLine[0] + ", " + nextLine[1] + ", " + nextLine[2]+ "," + nextLine[3] +")"; // myDatabase.rawQuery(sql, null); myDatabase.execSQL(sql); } } catch (IOException e) { // TODO Auto-generated catch block e.printStackTrace(); }

This is what the database looks like.

 public class FoodDatabase extends SQLiteOpenHelper { public static final String TABLE_FOOD = "food"; public static final String COLUMN_ID = "id"; public static final String COLUMN_NAME = "name"; public static final String COLUMN_SACHARIDES = "sacharides"; public static final String COLUMN_SACHARIDESPORTION = "sacharides_per_portion"; public static final String COLUMN_PORTIONSIZE = "portion_size"; public static final String COLUMN_GLYCEMIA = "glycemia"; public static final String COLUMN_CATEGORY1 = "category1"; public static final String COLUMN_CATEGORY2 = "category2"; public static final String COLUMN_CATEGORY3 = "category3"; private static final String DATABASE_NAME = "tables.db"; private static final int DATABASE_VERSION = 1; // Database creation sql statement private static final String DATABASE_CREATE = "create table " + TABLE_FOOD + "(" + COLUMN_ID + " integer primary key autoincrement, " + COLUMN_NAME + " text," + COLUMN_SACHARIDES + " real," + COLUMN_PORTIONSIZE + " integer," + COLUMN_SACHARIDESPORTION + " real," + COLUMN_GLYCEMIA + " integer,"+ COLUMN_CATEGORY1 + " integer," +COLUMN_CATEGORY2 + " integer," +COLUMN_CATEGORY3 + " integer);"; public FoodDatabase(Context context) { super(context, DATABASE_NAME, null, DATABASE_VERSION); } @Override public void onCreate(SQLiteDatabase database) { database.execSQL(DATABASE_CREATE); } @Override public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { Log.w(FoodDatabase.class.getName(), "Upgrading database from version " + oldVersion + " to " + newVersion + ", which will destroy all old data"); db.execSQL("DROP TABLE IF EXISTS " + TABLE_FOOD); onCreate(db); }
+4
source share
2 answers

I'm not sure, but you may need single quotes '' around the lines inside VALUES . Try:

 String sql = "INSERT INTO food (name, sacharides, glycemia, category1) " + "VALUES ('" + nextLine[0] + "', '" + nextLine[1] + "', '" + nextLine[2]+ "', '" + nextLine[3] +"' )";
+13
source

In my case

Unfortunately, the table name is incompatible.: ^) Have a rest. and continue!

+1
source

Source: https://habr.com/ru/post/1500963/

More articles:


All Articles