title: Android - How to clear textView?
body: <p>I have created an android app in java using eclipse which creates a Sqlite database and lets the user add data to it. Users can also search for existing data.
  I used android cursor objects.
  How do I clear the text box after a query is completed ?
  For example, I type "value" to retrieve all records associated with that value. Now I want to perform another search. When I click on the text box, I would like the text box to be cleared for my next search.</p>
  
  <p>This is part of my code for inserting and retrieving data :</p>
  
  <pre><code>db.execSQL("CREATE TABLE IF NOT EXISTS " + MY_DATABASE_TABLE + " (id INTEGER PRIMARY KEY AUTOINCREMENT, " + " name TEXT," + " number TEXT);");
  
  Cursor cur = db.rawQuery("INSERT INTO " + MY_DATABASE_TABLE + " (name, number)" + " VALUES ( \"" + newname + "\", \"" + newnumber + "\");", null);
  cur.moveToFirst();
  while (cur.isAfterLast() == false) 
  {
      result.append("\n" + "Id: " + cur.getString(0) + " | " + "Name: " + cur.getString(1) + " | " + "Phone Number: " + cur.getString(2) + "\n");
  
      cur.moveToNext();
  }
  cur.close(); 
  
  Cursor c = db.rawQuery("SELECT * FROM " + MY_DATABASE_TABLE, new String [] {}  );
  
  c.moveToFirst();
  
  while (c.isAfterLast() == false) {
      result.append("\n" + "Id: " + c.getString(0) + " | " + "Name: " + c.getString(1) + " | " + "Phone Number: " + c.getString(2) + "\n");
  
      c.moveToNext();
  }
  c.close();
  </code></pre>
  
  <p>Thanks.</p>