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