Android: Getting no such column, new developer

Android: Getting no such column, new developer

I'm brand new to developing and I am getting the following error in android:
08-24 23:55:15.744: E/AndroidRuntime(29803): Caused by:
android.database.sqlite.SQLiteException: no such column: customerName
(code 1): , while compiling: INSERT INTO nncdjiftable (customerName,
timeShift, date01, vendorGameThemePT, managerSignature, managerDate,
jackpotAmount, lessTaxesWithheld, cashierSignature, taxRate,
slotAttendantSignature, totalAmountPaid, slotSupervisorMODSignature,
customerSignature, date03) VALUES (customerName, timeShift, date01,
vendorGameThemePT, managerSignature, managerDate, jackpotAmount,
lessTaxesWithheld, cashierSignature, taxRate, slotAttendantSignature,
totalAmountPaid, slotSupervisorMODSignature, customerSignature, date03)
This is my code:
package com.mearle.nncdjif;
import android.app.Activity;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.graphics.Color;
import android.graphics.Typeface;
import android.os.Bundle;
import android.view.View;
import android.widget.EditText;
import android.widget.TableLayout;
import android.widget.TableRow;
import android.widget.TextView;
public class NNCDJIF_DataEntry extends Activity {
String customerName, timeShift, date01, vendorGameThemePT,
managerSignature, managerDate, jackpotAmount, lessTaxesWithheld,
cashierSignature, taxRate, slotAttendantSignature, totalAmountPaid,
slotSupervisorMODSignature, customerSignature, date03;
SQLiteDatabase nncdjifdb;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_nncdjif__data_entry);
nncdjifdb = openOrCreateDatabase("nncdjifdb", MODE_PRIVATE, null);
nncdjifdb
.execSQL("CREATE TABLE IF NOT EXISTS nncdjiftable(customerName
VARCHAR,timeShift VARCHAR,date01 VARCHAR,vendorGameThemePT
VARCHAR,managerSignature VARCHAR,managerDate
VARCHAR,jackpotAmount VARCHAR,lessTaxesWithheld
VARCHAR,cashier VARCHAR,taxRate VARCHAR,slotAttendant
VARCHAR,totalAmountPaid VARCHAR,slotSupervisorMOD
VARCHAR,customerSignature VARCHAR,date03 VARCHAR);");
}
public void Adddata(View view) {
EditText edittextCustomerName = (EditText)
findViewById(R.id.etCustomerName);
EditText edittextTimeShift = (EditText) findViewById(R.id.etTimeShift);
EditText edittextDate01 = (EditText) findViewById(R.id.etDate01);
EditText edittextVendorGameThemePT = (EditText)
findViewById(R.id.etVendorGameThemePT);
EditText edittextManagerSignature = (EditText)
findViewById(R.id.etManagerSignature);
EditText edittextManagerDate = (EditText)
findViewById(R.id.etManagerDate);
EditText edittextJackpotAmount = (EditText)
findViewById(R.id.etJackpotAmount);
EditText edittextLessTaxesWithheld = (EditText)
findViewById(R.id.etLessTaxesWithheld);
EditText edittextCashier = (EditText) findViewById(R.id.etCashier);
EditText edittextTaxRate = (EditText) findViewById(R.id.etTaxRate);
EditText edittextSlotAttendant = (EditText)
findViewById(R.id.etSlotAttendant);
EditText edittextTotalAmountPaid = (EditText)
findViewById(R.id.etTotalAmountPaid);
EditText edittextSlotSupervisorMOD = (EditText)
findViewById(R.id.etSlotSupervisorMOD);
EditText edittextCustomerSignature = (EditText)
findViewById(R.id.etCustomerSignature);
EditText edittextDate03 = (EditText) findViewById(R.id.etDate03);
customerName = edittextCustomerName.getText().toString();
timeShift = edittextTimeShift.getText().toString();
date01 = edittextDate01.getText().toString();
vendorGameThemePT = edittextVendorGameThemePT.getText().toString();
managerSignature = edittextManagerSignature.getText().toString();
managerDate = edittextManagerDate.getText().toString();
jackpotAmount = edittextJackpotAmount.getText().toString();
lessTaxesWithheld = edittextLessTaxesWithheld.getText().toString();
cashierSignature = edittextCashier.getText().toString();
taxRate = edittextTaxRate.getText().toString();
slotAttendantSignature = edittextSlotAttendant.getText().toString();
totalAmountPaid = edittextTotalAmountPaid.getText().toString();
slotSupervisorMODSignature = edittextSlotSupervisorMOD.getText()
.toString();
customerSignature = edittextCustomerSignature.getText().toString();
date03 = edittextDate03.getText().toString();
nncdjifdb
.execSQL("INSERT INTO nncdjiftable (customerName, timeShift,
date01, vendorGameThemePT, managerSignature, managerDate,
jackpotAmount, lessTaxesWithheld, cashierSignature, taxRate,
slotAttendantSignature, totalAmountPaid,
slotSupervisorMODSignature, customerSignature, date03) VALUES
(customerName, timeShift, date01, vendorGameThemePT,
managerSignature, managerDate, jackpotAmount,
lessTaxesWithheld, cashierSignature, taxRate,
slotAttendantSignature, totalAmountPaid,
slotSupervisorMODSignature, customerSignature, date03)");
}
private void Showdata(View view) {
Cursor c = nncdjifdb.rawQuery("SELECT * FROM nncdjiftable", null);
int count = c.getCount();
c.moveToFirst();
TableLayout tableLayout = new TableLayout(getApplicationContext());
tableLayout.setVerticalScrollBarEnabled(true);
TableRow tableRow;
TextView textviewcustomerName, textviewtimeShift, textviewdate01,
textviewvendorGameThemePT, textviewmanagerSignature,
textviewmanagerDate, textviewjackpotAmount, textviewlessTaxesWithheld,
textviewcashierSignature, textviewtaxRate,
textviewslotAttendantSignature, textviewtotalAmountPaid,
textviewslotSupervisorMODSignature, textviewcustomerSignature,
textviewdate03, textviewDcustomerName, textviewDtimeShift,
textviewDdate01, textviewDvendorGameThemePT,
textviewDmanagerSignature, textviewDmanagerDate,
textviewDjackpotAmount, textviewDlessTaxesWithheld,
textviewDcashierSignature, textviewDtaxRate,
textviewDslotAttendantSignature, textviewDtotalAmountPaid,
textviewDslotSupervisorMODSignature, textviewDcustomerSignature,
textviewDdate03;
tableRow = new TableRow(getApplicationContext());
textviewcustomerName = new TextView(getApplicationContext());
textviewcustomerName.setText("Customer Name");
textviewcustomerName.setTextColor(Color.RED);
textviewcustomerName.setTypeface(null, Typeface.BOLD);
textviewcustomerName.setPadding(20, 20, 20, 20);
tableRow.addView(textviewcustomerName);
textviewtimeShift = new TextView(getApplicationContext());
textviewtimeShift.setText("Time/Shift");
textviewtimeShift.setTextColor(Color.RED);
textviewtimeShift.setTypeface(null, Typeface.BOLD);
textviewtimeShift.setPadding(20, 20, 20, 20);
tableRow.addView(textviewtimeShift);
textviewdate01 = new TextView(getApplicationContext());
textviewdate01.setText("Date");
textviewdate01.setTextColor(Color.RED);
textviewdate01.setTypeface(null, Typeface.BOLD);
textviewdate01.setPadding(20, 20, 20, 20);
tableRow.addView(textviewdate01);
textviewvendorGameThemePT = new TextView(getApplicationContext());
textviewvendorGameThemePT.setText("Vendor/Game Theme/PT#");
textviewvendorGameThemePT.setTextColor(Color.RED);
textviewvendorGameThemePT.setTypeface(null, Typeface.BOLD);
textviewvendorGameThemePT.setPadding(20, 20, 20, 20);
tableRow.addView(textviewvendorGameThemePT);
textviewmanagerSignature = new TextView(getApplicationContext());
textviewmanagerSignature.setText("Manager Signature");
textviewmanagerSignature.setTextColor(Color.RED);
textviewmanagerSignature.setTypeface(null, Typeface.BOLD);
textviewmanagerSignature.setPadding(20, 20, 20, 20);
tableRow.addView(textviewmanagerSignature);
textviewmanagerDate = new TextView(getApplicationContext());
textviewmanagerDate.setText("Date");
textviewmanagerDate.setTextColor(Color.RED);
textviewmanagerDate.setTypeface(null, Typeface.BOLD);
textviewmanagerDate.setPadding(20, 20, 20, 20);
tableRow.addView(textviewmanagerDate);
textviewjackpotAmount = new TextView(getApplicationContext());
textviewjackpotAmount.setText("Jackpot Amount");
textviewjackpotAmount.setTextColor(Color.RED);
textviewjackpotAmount.setTypeface(null, Typeface.BOLD);
textviewjackpotAmount.setPadding(20, 20, 20, 20);
tableRow.addView(textviewjackpotAmount);
textviewlessTaxesWithheld = new TextView(getApplicationContext());
textviewlessTaxesWithheld.setText("Less Taxes Withheld");
textviewlessTaxesWithheld.setTextColor(Color.RED);
textviewlessTaxesWithheld.setTypeface(null, Typeface.BOLD);
textviewlessTaxesWithheld.setPadding(20, 20, 20, 20);
tableRow.addView(textviewlessTaxesWithheld);
textviewcashierSignature = new TextView(getApplicationContext());
textviewcashierSignature.setText("Cashier");
textviewcashierSignature.setTextColor(Color.RED);
textviewcashierSignature.setTypeface(null, Typeface.BOLD);
textviewcashierSignature.setPadding(20, 20, 20, 20);
tableRow.addView(textviewcashierSignature);
textviewtaxRate = new TextView(getApplicationContext());
textviewtaxRate.setText("Tax Rate");
textviewtaxRate.setTextColor(Color.RED);
textviewtaxRate.setTypeface(null, Typeface.BOLD);
textviewtaxRate.setPadding(20, 20, 20, 20);
tableRow.addView(textviewtaxRate);
textviewslotAttendantSignature = new TextView(getApplicationContext());
textviewslotAttendantSignature.setText("Slot Attendant");
textviewslotAttendantSignature.setTextColor(Color.RED);
textviewslotAttendantSignature.setTypeface(null, Typeface.BOLD);
textviewslotAttendantSignature.setPadding(20, 20, 20, 20);
tableRow.addView(textviewslotAttendantSignature);
textviewtotalAmountPaid = new TextView(getApplicationContext());
textviewtotalAmountPaid.setText("Total Amount Paid");
textviewtotalAmountPaid.setTextColor(Color.RED);
textviewtotalAmountPaid.setTypeface(null, Typeface.BOLD);
textviewtotalAmountPaid.setPadding(20, 20, 20, 20);
tableRow.addView(textviewtotalAmountPaid);
textviewslotSupervisorMODSignature = new TextView(
getApplicationContext());
textviewslotSupervisorMODSignature.setText("Slot Supervisor/M.O.D.");
textviewslotSupervisorMODSignature.setTextColor(Color.RED);
textviewslotSupervisorMODSignature.setTypeface(null, Typeface.BOLD);
textviewslotSupervisorMODSignature.setPadding(20, 20, 20, 20);
tableRow.addView(textviewslotSupervisorMODSignature);
textviewcustomerSignature = new TextView(getApplicationContext());
textviewcustomerSignature.setText("Customer Signature");
textviewcustomerSignature.setTextColor(Color.RED);
textviewcustomerSignature.setTypeface(null, Typeface.BOLD);
textviewcustomerSignature.setPadding(20, 20, 20, 20);
tableRow.addView(textviewcustomerSignature);
textviewdate03 = new TextView(getApplicationContext());
textviewdate03.setText("Date");
textviewdate03.setTextColor(Color.RED);
textviewdate03.setTypeface(null, Typeface.BOLD);
textviewdate03.setPadding(20, 20, 20, 20);
tableRow.addView(textviewdate03);
tableLayout.addView(tableRow);
for (Integer j = 0; j < count; j++) {
tableRow = new TableRow(getApplicationContext());
textviewDcustomerName = new TextView(getApplicationContext());
textviewDcustomerName.setText(c.getString(c
.getColumnIndex("customerName")));
textviewDtimeShift = new TextView(getApplicationContext());
textviewDtimeShift.setText(c.getString(c
.getColumnIndex("timeShift")));
textviewDdate01 = new TextView(getApplicationContext());
textviewDdate01.setText(c.getString(c.getColumnIndex("date01")));
textviewDvendorGameThemePT = new TextView(getApplicationContext());
textviewDvendorGameThemePT.setText(c.getString(c
.getColumnIndex("vendorGameThemePT")));
textviewDmanagerSignature = new TextView(getApplicationContext());
textviewDmanagerSignature.setText(c.getString(c
.getColumnIndex("managerSignature")));
textviewDmanagerDate = new TextView(getApplicationContext());
textviewDmanagerDate.setText(c.getString(c
.getColumnIndex("managerDate")));
textviewDjackpotAmount = new TextView(getApplicationContext());
textviewDjackpotAmount.setText(c.getString(c
.getColumnIndex("jackpotAmount")));
textviewDlessTaxesWithheld = new TextView(getApplicationContext());
textviewDlessTaxesWithheld.setText(c.getString(c
.getColumnIndex("lessTaxesWithheld")));
textviewDcashierSignature = new TextView(getApplicationContext());
textviewDcashierSignature.setText(c.getString(c
.getColumnIndex("cashierSignature")));
textviewDtaxRate = new TextView(getApplicationContext());
textviewDtaxRate.setText(c.getString(c.getColumnIndex("taxRate")));
textviewDslotAttendantSignature = new TextView(
getApplicationContext());
textviewDslotAttendantSignature.setText(c.getString(c
.getColumnIndex("slotAttendantSignature")));
textviewDtotalAmountPaid = new TextView(getApplicationContext());
textviewDtotalAmountPaid.setText(c.getString(c
.getColumnIndex("totalAmountPaid")));
textviewDslotSupervisorMODSignature = new TextView(
getApplicationContext());
textviewDslotSupervisorMODSignature.setText(c.getString(c
.getColumnIndex("slotSupervisorMODSignature")));
textviewDcustomerSignature = new TextView(getApplicationContext());
textviewDcustomerSignature.setText(c.getString(c
.getColumnIndex("customerSignature")));
textviewDdate03 = new TextView(getApplicationContext());
textviewDdate03.setText(c.getString(c.getColumnIndex("date03")));
textviewDcustomerName.setPadding(20, 20, 20, 20);
textviewDtimeShift.setPadding(20, 20, 20, 20);
textviewDdate01.setPadding(20, 20, 20, 20);
textviewDvendorGameThemePT.setPadding(20, 20, 20, 20);
textviewDmanagerSignature.setPadding(20, 20, 20, 20);
textviewDmanagerDate.setPadding(20, 20, 20, 20);
textviewDjackpotAmount.setPadding(20, 20, 20, 20);
textviewDlessTaxesWithheld.setPadding(20, 20, 20, 20);
textviewDcashierSignature.setPadding(20, 20, 20, 20);
textviewDtaxRate.setPadding(20, 20, 20, 20);
textviewDslotAttendantSignature.setPadding(20, 20, 20, 20);
textviewDtotalAmountPaid.setPadding(20, 20, 20, 20);
textviewDslotSupervisorMODSignature.setPadding(20, 20, 20, 20);
textviewDcustomerSignature.setPadding(20, 20, 20, 20);
textviewDdate03.setPadding(20, 20, 20, 20);
tableRow.addView(textviewDcustomerName);
tableRow.addView(textviewDtimeShift);
tableRow.addView(textviewDdate01);
tableRow.addView(textviewDvendorGameThemePT);
tableRow.addView(textviewDmanagerSignature);
tableRow.addView(textviewDmanagerDate);
tableRow.addView(textviewDjackpotAmount);
tableRow.addView(textviewDlessTaxesWithheld);
tableRow.addView(textviewDcashierSignature);
tableRow.addView(textviewDtaxRate);
tableRow.addView(textviewDslotAttendantSignature);
tableRow.addView(textviewDtotalAmountPaid);
tableRow.addView(textviewDslotSupervisorMODSignature);
tableRow.addView(textviewDcustomerSignature);
tableRow.addView(textviewDdate03);
tableLayout.addView(tableRow);
c.moveToNext();
}
setContentView(tableLayout);
nncdjifdb.close();
}
public void close(View view) {
System.exit(0);
}
}