Welcome to the Treehouse Community
Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.
Looking to learn something new?
Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.
Start your free trialEvgeniy Bobrovnichiy
3,165 PointsWhere I have a mistake in this??
I all do how is been in video but don't understand where I have a mistake!
public class AlienSQLiteHelper extends SQLiteOpenHelper {
public static final String DB_NAME = "aliens.db";
public static final int DB_VERSION = 2;
public static final String ALIENS_TABLE = "ALIENS";
public static final String COLUMN_NAME = "NAME";
public static final String COLUMN_TYPE = "TYPE";
public static final String COLUMN_HOME_PLANET = "HOME_PLANET";
public static final String CREATE_ALIENS = "CREATE TABLE " + ALIENS_TABLE + " (" +
"_id INTEGER PRIMARY KEY AUTOINCREMENT," +
COLUMN_NAME + " TEXT, " +
COLUMN_TYPE + " TEXT," +
COLUMN_HOME_PLANET + " TEXT)";
public static final String DB_ALTER = "ALTER TABLE " + ALIENS_TABLE + " ADD COLUMN " + COLUMN_HOME_PLANET + "TEXT";
public AlienSQLiteHelper(Context context) {
super(context, DB_NAME, null, DB_VERSION);
}
@Override
public void onCreate(SQLiteDatabase sqLiteDatabase) {
sqLiteDatabase.execSQL(CREATE_ALIENS);
}
@Override
public void onUpgrade(SQLiteDatabase database, int oldVersion, int newVersion) {
switch (oldVersion) {
case 1:
database.execSQL(DB_ALTER);
}
}
}
5 Answers
Mazen Halawi
7,806 PointsYour error should be onUpgrade method, you will need to DROP the table first and fire the onCreate function again.
Evgeniy Bobrovnichiy
3,165 PointsThanks you for help I found the mistake before!
Mazen Halawi
7,806 Pointsno problem, kindly mark it as solved so that other users move on.
cheers!
Evgeniy Bobrovnichiy
3,165 Pointspublic class AlienSQLiteHelper extends SQLiteOpenHelper {
public static final String DB_NAME = "aliens.db"; public static final int DB_VERSION = 2;
public static final String ALIENS_TABLE = "ALIENS"; public static final String COLUMN_NAME = "NAME"; public static final String COLUMN_TYPE = "TYPE"; public static final String COLUMN_HOME_PLANET = "HOME_PLANET";
public static final String CREATE_ALIENS = "CREATE TABLE " + ALIENS_TABLE + " (" + "_id INTEGER PRIMARY KEY AUTOINCREMENT," + COLUMN_NAME + " TEXT, " + COLUMN_TYPE + " TEXT, " + COLUMN_HOME_PLANET + "TEXT)";
// public static final String DB_ALTER = "ALTER TABLE " + ALIENS_TABLE + " ADD COLUMN " + COLUMN_HOME_PLANET ;
public static final String DB_ALTER = "ALTER TABLE " + ALIENS_TABLE + " ADD COLUMN " + COLUMN_HOME_PLANET + " TEXT ";
public AlienSQLiteHelper(Context context) { super(context, DB_NAME, null, DB_VERSION); }
@Override public void onCreate(SQLiteDatabase sqLiteDatabase) { sqLiteDatabase.execSQL(CREATE_ALIENS); }
@Override
public void onUpgrade(SQLiteDatabase database, int oldVersion, int newVersion) {
switch (oldVersion) {
case 1:
database.execSQL(DB_ALTER);
}
}
}
Evgeniy Bobrovnichiy
3,165 PointsThis code really work!