Android : Sqlite Update query syntax error

on Wednesday, April 15, 2015


whenever I try to update details I get syntax error near nRating



public void addRating(String name, String nDate, String nRating,
String nComment)
{

SQLiteDatabase data = this.getWritableDatabase();

Cursor query = data.rawQuery("update Station Set " + " date " + " = "
+ nDate + "," + " rating " + nRating + "," + " comments "
+ nComment + " Where Stationname " + " = " + name, null);
query.close();

}

0 comments:

Post a Comment