Sqllite doesn' write a column
- by user1904675
I do this:
DatabaseHelper dbHelper = new DatabaseHelper(context);
dbHelper.getWritableDatabase();
String sql = "insert into "+getTableName()+("+DatabaseHelper.PRODUCT_MARK+","+DatabaseHelper.PRODUCT_NAME+") VALUES ('"+input.getMark()+"','"+input.getName()+"')";
System.out.println(sql);
getDatabase().execSQL(sql);
dbHelper.close();
The system print
12-14 16:53:33.857: I/System.out(1350): insert into product (pMark,name) VALUES ('aaaaa ','zz')
But when I read from db the property mark is not valorized...
Where is my mistake?