title: Eclipse Android - Database row ID should always "1" is it possible?
body: <p>I'm new in android and trying to make an app that you will input a message in an edittext and send it to another activity with a row ID = "1' in database, once it is sent</p>
  
  <p>Another activity will receive this message and if the button named "Delete this message" is clicked the the messsage will be deleted in the database at the same time it's row ID</p>
  
  <p>Once it is deleted, I can enter again a message with a row ID = "1" in database.</p>
  
  <p>here is my code</p>
  
  <pre><code> package com.example.pmfinal;
  
     import java.sql.SQLException;
  
     import android.content.ContentValues;
     import android.content.Context;
     import android.database.Cursor;
     import android.database.sqlite.SQLiteDatabase;
     import android.database.sqlite.SQLiteOpenHelper;
  
  
      public class DatabasePM {
  
  private static final String DATABASE_NAME = "InfoDb";
  private static final int DATABASE_VERSION = 1;
  
  public static final String KEY_ROWIDPM = "_id";
  public static final String NOTIFPM = "notifpm";
  
  
  
  private static final String TABLE_NOTIFPM = "notifprojman";
  
  private static final String CREATE_NOTIFPM = "CREATE TABLE " + TABLE_NOTIFPM + " ("       +
  KEY_ROWIDPM + " INTEGER PRIMARY KEY, " +
  NOTIFPM + " TEXT NOT NULL); ";
  
  
  
  private DbHelper ourHelper;
  private Context ourContext;
  private SQLiteDatabase ourDatabase;
  
  private static class DbHelper extends SQLiteOpenHelper{
  
      public DbHelper(Context Context) {
          super(Context, DATABASE_NAME, null, DATABASE_VERSION);
          // TODO Auto-generated constructor stub
      }
  
      public void onCreate(SQLiteDatabase db) {
          // TODO Auto-generated method stub
          db.execSQL(CREATE_NOTIFPM);
          ;
  
  
      }
  
      @Override
      public void onUpgrade(SQLiteDatabase db, int arg1, int arg2) {
          // TODO Auto-generated method stub
          db.execSQL("DROP TABLE IF EXIST " + TABLE_NOTIFPM);
  
  
          onCreate(db);
      }
  }
  
  public DatabasePM(Context c){
      ourContext = c;
  }
  
  public DatabasePM open() throws SQLException{
      ourHelper = new DbHelper(ourContext);
      ourDatabase = ourHelper.getWritableDatabase();
      return this;
  }
  public void close(){
      ourHelper.close();
  }
  
  
  
  public long createProject(String notifpm) {
      // TODO Auto-generated method stub
      ContentValues cv = new ContentValues();
      cv.put(NOTIFPM, notifpm);
      return ourDatabase.insert(TABLE_NOTIFPM, null, cv);
  }
  
  public String getNotif(long l) {
      String[] columns = new String[]{ KEY_ROWIDPM, NOTIFPM};
  
      Cursor c = ourDatabase.query(TABLE_NOTIFPM, columns, KEY_ROWIDPM + "=" + l , null, null, null, null);
      if (c != null) {
          c.moveToFirst();
          String notif = c.getString(1);
          return notif;
      }
      return null;
  }
  
  public void deleteNotifPM(long l) {
      // TODO Auto-generated method stub
      ourDatabase.delete(TABLE_NOTIFPM, KEY_ROWIDPM + "=" + l , null);
  }
  
  
  
  }
  </code></pre>