z183052114
2017-03-21 07:06sqlite 报错 no such column,请问错在哪?
String sqlcar = "create table if not exists cardinformation(id integer primary key autoincrement not null, name varchar, sno varchar," +
"gender varchar, department varchar, cardCode varchar, state varchar, imgUrl varchar,img BLOB)";
db.execSQL(sqlcar);
ContentValues values = new ContentValues();
ByteArrayOutputStream os = new ByteArrayOutputStream();
bitmap.compress(Bitmap.CompressFormat.PNG, 100, os);
values.put("img", os.toByteArray());
String[] arr= new String[1];
arr[0] = strings[1];
long i = WelcomeActivity.db.update("cardinformation",values,"cardCode = ?",arr);
Caused by: android.database.sqlite.SQLiteException: no such column: img (code 1): , while compiling: UPDATE cardinformation SET img=? WHERE cardCode = ?
- 点赞
- 回答
- 收藏
- 复制链接分享
3条回答
为你推荐
- 为什么运行查询和删除数据库时闪退?
- android-studio
- android
- 2个回答
- sqlite插入显示no such column:【value】
- android
- sqlite
- 2个回答
- Python数据库案例,书上的代码为什么不能正常运行呢?
- 数据库
- python
- sqlite
- 6个回答
- android中sqlite一直报错
- android
- sqlite
- 3个回答
- 出现错误:SQLiteException: no such table: tabella (code1)
- sql
- android
- database
- 2个回答
换一换