Hopefully some one will nmotice my 'obvious' mistake. I have created 2 tables in the database (below). When I access table c, no problem. But when I attempt to access table s I get an error message that column name x (all names give the same error) does not exist. How can 1 table get created but not the other?
public class updateDB extends SQLiteOpenHelper { private static final String CREATE_TABLE_S = "create table "+DICT_TAB_1+" (_ID integer primary key autoincrement, COURSE_NAME text not null, SCORE number not null, PUTTS number not null, GIR number not null, FWY number not null);"; private static final String CREATE_TABLE_C = "create table "+DICT_TAB_2+" (_ID integer primary key autoincrement, COURSE_NAME text not null, TEES text not null, SLOPE number not null, PAR number not null);"; public updateDB(Context ctx){ super(ctx, DATABASE_NAME, null, DATABASE_VERSION); } @Override public void onCreate(SQLiteDatabase db){ db.execSQL(CREATE_TABLE_COURSE); db.execSQL(CREATE_TABLE_SCORE); } @Override public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion){ db.execSQL("DROP TABLE IF EXISTS "+ DICT_TAB_1); db.execSQL("DROP TABLE IF EXISTS "+ DICT_TAB_2); onCreate(db); } } --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en -~----------~----~----~----~------~----~------~--~---