title: I'm new in the android field and suffering with the problem for insertion in the android app?
body: <p>I made simply a insertion folrm which will take the three numbers as input to store in the database (Please keep note that  i'm working with the sqlite database).
  So the main thing is when i click on submit it will through an error which says no such table :-messgae_table.
  And i try to find what is the problem with my code but nothing is worked out for me!!!!
  PLEASE HELP ME OUT AT THIS.......</p>
  
  <p>Main Activity.java page:-</p>
  
  <pre><code>button.setOnClickListener(new View.OnClickListener() {
              @Override
              public void onClick(View view) {
                  try{
                      DatabaseQueries db=new DatabaseQueries(Main2Activity.this);
                      Log.e("data",editText1.getText().toString());
                      long result=db.addMessageNumber(editText1.getText().toString(),editText2.getText().toString(),editText3.getText().toString());
                      if (result&gt;0){
                          Toast.makeText(Main2Activity.this, "Inserted", Toast.LENGTH_SHORT).show();
                      }
                      else {
                          Toast.makeText(Main2Activity.this, "Not Inserted", Toast.LENGTH_SHORT).show();
                      }
                  }
                  catch (Exception e){
                      e.getMessage();
                      e.printStackTrace();
  
                  }
  
  
  </code></pre>
  
  <p>DatabaseColumn.java:-</p>
  
  <pre><code>public static final String MESSAGE_TABLE = "message_table";
      public static final String MESSAGE_NUMBERONE = "message_numberone";
      public static final String MESSAGE_NUMBERTWO = "messgae_numbertwo";
      public static final String MESSAGE_NUMBERTHREE = "message_numberthree";
  </code></pre>
  
  <p>DatabaseCreation:-</p>
  
  <pre><code>public class DatabaseCreation extends SQLiteOpenHelper {
      private static String DB_NAME = "secure.db";
      private static int DB_VERSION = 1;
  
  
      private String message_table = "CREATE TABLE " + DatabaseColumn.MESSAGE_TABLE + " ( " + DatabaseColumn.MESSAGE_NUMBERONE + " TEXT, " + DatabaseColumn.MESSAGE_NUMBERTWO + " TEXT, " + DatabaseColumn.MESSAGE_NUMBERTHREE + " TEXT )";
  
      public DatabaseCreation(Context context){
  
          super(context, DB_NAME,null,DB_VERSION);
      }
  
      @Override
      public void onCreate(SQLiteDatabase sqLiteDatabase) {
          sqLiteDatabase.execSQL(contact_table);
          sqLiteDatabase.execSQL(message_table);
  
      }
  
      @Override
      public void onUpgrade(SQLiteDatabase sqLiteDatabase, int i, int i1) {
  
      }
  }
  
  </code></pre>
  
  <p>DatabaseQueries:-</p>
  
  <pre><code>public long addMessageNumber(String numberone, String numbertwo, String numberthree){
          SQLiteDatabase sqLiteDatabase2=db.getWritableDatabase();
          ContentValues cv=new ContentValues();
          cv.put(DatabaseColumn.MESSAGE_NUMBERONE,numberone);
          cv.put(DatabaseColumn.MESSAGE_NUMBERTWO,numbertwo);
          cv.put(DatabaseColumn.MESSAGE_NUMBERTHREE,numberthree);
          long result=sqLiteDatabase2.insert(DatabaseColumn.MESSAGE_TABLE,null,cv);
          sqLiteDatabase2.close();
          return result;
      }
  </code></pre>