java– 在SQLite上运行更新时“没有这样的列”

概述我正在尝试更新数据库中的一行.这是我试图用来更新的代码：publicvoidaddFBComments(intid){SQLiteDatabasedb=this.getWritableDatabase();Stringquery="UPDATE"+TABLE_FB_FEED+"SET"+COL_FB_COMMENTS+"="+"HELLO"+"WH

我正在尝试更新数据库中的一行.这是我试图用来更新的代码：

public voID addFBComments(int ID){     sqliteDatabase db = this.getWritableDatabase();     String query = "UPDATE " + table_FB_Feed + " SET " + Col_FB_COMMENTS+"="+"HELLO" + " WHERE " + Col_FB_ID+"="+ID;    db.execsql(query);}

当我运行该命令时,它会抛出此错误：

08-18 15:42:10.145: E/AndroIDRuntime(10493): FATAL EXCEPTION: Thread-92208-18 15:42:10.145: E/AndroIDRuntime(10493): androID.database.sqlite.sqliteException: no such column: HELLO (code 1): , while compiling: UPDATE fb_Feed SET fb_comments= HELLO  WHERE _ID=3

这是table_FB_Feed：

private static final String table_FB_Feed_CREATE = "create table " + table_FB_Feed + " ("        + Col_FB_ID + " integer primary key autoincrement not null,"         + Col_FB_MESSAGE + " text,"         + Col_FB_CAPTION + " text,"        + Col_FB_POSTER_ID + " text,"        + Col_FB_POST_ID + " text,"        + Col_FB_liKES + " text,"        + Col_FB_POSTER_name + " text,"        + Col_FB_COMMENTS + " text," // this is the column i want to update        + Col_FB_liKES_NUM + " text,"        + Col_FB_TIMESTAMP + " text,"        + Col_FB_PROfile_PICTURE_URI + " text,"        + Col_FB_PICTURE_URI + " text,"         + Col_FB_name + " text,"         + Col_FB_PREVIoUS_PAGE_URI + " text,"        + Col_FB_NEXT_PAGE_URI + " text,"         + Col_FB_POST_TYPE + " text,"         + Col_FB_link_name + " text,"         + Col_FB_COMMENTS_NUM + " text,"         + Col_FB_STORY + " text,"         + Col_FB_DESCRIPTION + " text,"        + Col_FB_COMMENTS_BEFORE + " text,"        + Col_FB_COMMENTS_AFTER + " text,"        + Col_FB_liKES_PROfile_PIC + " text,"        + Col_FB_COMMENTS_PROfile_PIC + " text);";

为什么抛出查询？我以为我正在做的一切都正确.

解决方法:

在您的代码中,您需要添加单引号：

String query = "UPDATE " + table_FB_Feed + " SET " + Col_FB_COMMENTS    +"="+"'HELLO'" + " WHERE " + Col_FB_ID+"="+ID

要么

String query = "UPDATE " + table_FB_Feed + " SET " + Col_FB_COMMENTS    +"='HELLO' WHERE " + Col_FB_ID+"="+ID

这是另一个例子

"UPDATE DB_table SET YOUR_ColUMN='newValue' WHERE ID=myIDValue");

总结

以上是内存溢出为你收集整理的java – 在SQLite上运行更新时“没有这样的列”全部内容，希望文章能够帮你解决java – 在SQLite上运行更新时“没有这样的列”所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。