title: How to update my string value into database
body: <p>Have a database with table name <code>status</code> and column name is <code>column1</code>. I need to update this.</p>
  
  <p>I have a String value in <code>Activity1</code> </p>
  
  <pre><code>String check = "value";
  </code></pre>
  
  <p>I have passed this value into my <code>DBHelper</code>.I have tried like this </p>
  
  <pre><code>dbhelper = new DBHelper(this);
  dbhelper.sample(check);
  </code></pre>
  
  <p>I got this value in <code>DBHelpe</code>r.here. Like this</p>
  
  <pre><code>public void sample(String prms){
  Log.d("sucess",prms);
  }
  </code></pre>
  
  <p>Now how i need to update <code>String prms</code> into my database columnname <code>column1</code></p>
  
  <p>I have tried like this</p>
  
  <pre><code>public  void sample( String prms) {
          Log.d("DBHELPER SUCCESS", prms);
  
          try{
              SQLiteDatabase db1 = this.getWritableDatabase(); 
              db1.execSQL("update appstatus SET status = '"+prms+"' WHERE id = 1 ");
          }catch(Exception e){
              System.out.println("GET SAMPLE VALUE"+e);
          }
      }
  </code></pre>
  
  <p>What's wrong with my syntax? How to achieve this?</p>
  
  <p>It shows exception as</p>
  
  <pre><code>02-28 12:09:45.604: I/System.out(4975): GET SAMPLE VALUEandroid.database.sqlite.SQLiteException: table report already exists (code 1): , while compiling: create table report(level TEXT, topic TEXT,  start TEXT, end TEXT, date TEXT)
  </code></pre>