title: Failed to Insert Data in SQLITE DataBase using Java in Android?
body: <p>i am newbie in android here is the table : </p>
  
  <pre><code>    private static final String parameterString = "CREATE TABLE IF NOT EXISTS parameterTable(ID INTEGER PRIMARY KEY AUTOINCREMENT,param_type TEXT,cash_code TEXT,param_description TEXT)";
  dataBaseAdapterInstance = new DataBaseAdapter(context);
         @Override
          public void onCreate(SQLiteDatabase db) {
              db.execSQL(parameterString);
      }
  private void setHardCodedSpinnerValue()
  {
  dataBaseAdapterInstance.openToWrite();
  final String endUserContractorArray[] = {"End User -With Risk Assessment","End User -Without Risk Assessment", "Contractor" };
  
  String query =  "INSERT  INTO parameterTable(ID,param_type,cash_code,param_description) " +
   "VALUES ('331','"+endUserContractorArray[0]+"','"EUWRA"','"End User With Risk Assessment"');";
  dataBaseAdapterInstance.getDatabaseInstance().execSQL(query);
  }
  </code></pre>
  
  <p>I am getting error on this line</p>
  
  <pre><code>String query =  "INSERT  INTO parameterTable(ID,param_type,cash_code,param_description) " +
   "VALUES ('331','"+endUserContractorArray[0]+"','"EUWRA"','"End User With Risk Assessment"');";
  </code></pre>
  
  <p>These are the hardcode values  <strong>EUWRA"','"End User With Risk Assessment"'</strong><br>
    dataBaseAdapterInstance has already declared.The error is when i am trying to insert hardcoded Values.Please help me what am i doing wrong ? </p>