lundi 5 octobre 2015

"table has no column named BenefitText" sqlite database error [duplicate]

This question already has an answer here:

This is the error I am getting

E/SQLiteLog: (1) table OfflineSyncTable has no column named BenefitText10-05 21:27:48.544 24285-24376/com.salesapp.whatsextra 
E/SQLiteDatabase: Error inserting BenefitText=11% CheckInID=9699362547 Amount=200 BrandName=Red Moments DOB=01-Jan-1900 SaleType=sale Time=Oct 05, 2015 09:27 pm Name=Hirak Voucher= Address=

This is my create table query

db.execSQL("create table if not exists " + CHECKOUT_TABLE_NAME + "(" + COL_ID + " integer primary key autoincrement, " +
            "" + CHECKINID + " varchar, " + BRAND_NAME + " varchar, " +
            "" + ADDRESS + " varchar, " + SALE_TYPE + " varchar, " + AMOUNT + " varchar, " + VOUCHER + " varchar, " +
            "" + BENEFIT_TEXT + " varchar, " + NAME + " varchar, " + DOB + " varchar)");

I can't figure out what is the issue here.

Here is insert query -

public boolean insertCheckOut (String clientId, String brandName, String address, String saleType, String amount,
                               String voucher, String benefitText, String name, String dob, String time){

    SQLiteDatabase database = this.getWritableDatabase();

    ContentValues contentValues = new ContentValues();
    contentValues.put(CHECKINID, clientId);
    contentValues.put(BRAND_NAME, brandName);
    contentValues.put(ADDRESS, address);
    contentValues.put(SALE_TYPE, saleType);
    contentValues.put(AMOUNT, amount);
    contentValues.put(VOUCHER, voucher);
    contentValues.put(BENEFIT_TEXT, benefitText);
    contentValues.put(NAME, name);
    contentValues.put(DOB, dob);
    contentValues.put(TIME, time);

    long result = database.insert(CHECKOUT_TABLE_NAME, null, contentValues);

    return result != -1;
}

Aucun commentaire:

Enregistrer un commentaire