Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Mobile Development
  3. Android
  4. Android Eclipse SQLiteDatabase OnCreate is not called

Android Eclipse SQLiteDatabase OnCreate is not called

Scheduled Pinned Locked Moved Android
databaseandroidhelptutoriallearning
1 Posts 1 Posters 3 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • I Offline
    I Offline
    itforum Question
    wrote on last edited by
    #1

    Please can you guide me to resolve in my code . I am a beginner in Android development. In my code On Create method is not calling

    public class mtsDatabaseHelper extends SQLiteOpenHelper 
    

    {
    private static final String DATABASE_NAME="fleetdatabase";
    private static final String TABLE_NAME="USERS_TABLE";
    private static final int DATABASE_VERSION = 1;
    private static final String UID = "_id";
    private static final String NAME = "Name";
    private static final String CREATE_TABLE = "CREATE TABLE "+TABLE_NAME+" ("+UID+" INTEGER PRIMARY KEY AUTOINCREMENT, "+NAME+" VARCHAR(50));";
    private static final String DROP_TABLE = "DROP TABLE "+TABLE_NAME+" IF EXISTS";
    private Context context;
    public mtsDatabaseHelper(Context context)
    {
    super(context,DATABASE_NAME,null,DATABASE_VERSION);
    this.context = context;
    Message.message(context, "Constructor called");
    }

    public void onCreate(SQLiteDatabase db)
    {
    	// TODO Auto-generated method stub
        try
        {
        db.execSQL(CREATE\_TABLE);
        Message.message(context, "On Create called");
        }
        catch(SQLException e)
        {
                        Message.message(context, ""+e);
        }
    
    
    }
    
    public void onUpgrade(SQLiteDatabase db, int oldversion, int newversion) 
    {
    	// TODO Auto-generated method stub
        try 
        {
                        Message.message(context, "On Upgrade called");
                        db.execSQL(DROP\_TABLE);
                        onCreate(db);
        } catch (SQLException e) 
        {
                        // TODO Auto-generated catch block
                        Message.message(context, ""+e);
        }
    
    
    }
    

    }

    public class MainActivity extends Activity
    {
    mtsDatabaseHelper mtsdatabasehelper;
    @Override
    protected void onCreate(Bundle savedInstanceState)
    {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.activity_main);
    mtsdatabasehelper = new mtsDatabaseHelper(this);
    SQLiteDatabase sqlitdatabase = mtsdatabasehelper.getWritableDatabase();

    }
    

    Please help

    1 Reply Last reply
    0
    Reply
    • Reply as topic
    Log in to reply
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes


    • Login

    • Don't have an account? Register

    • Login or register to search.
    • First post
      Last post
    0
    • Categories
    • Recent
    • Tags
    • Popular
    • World
    • Users
    • Groups