Hi there I am trying to create a database with two tables. Employees and Computers. A spinner with employee names fill properly when I don't try create and do anything with the second table... The code to create is:
private static class DBOpenHelper extends SQLiteOpenHelper { private static final String CREATE_TABLE_USERS = "create table " + TABLE_USERS + " (" + USER_KEY_ID + " integer primary key autoincrement, " + USER_KEY_USER + " text not null, " + USER_KEY_PIN + " string);"; private static final String CREATE_TABLE_ACCOUNTS = "create table " + TABLE_COMPUTERS + " (" + ACC_KEY_ID + " integer primary key autoincrement, " + ACC_KEY_USERID + " integer not null, " + ACC_KEY_COMP_SERIAL + " text not null);"; public DBOpenHelper(Context context, String name, CursorFactory factory, int version) { super(context, name, factory, version); } @Override public void onCreate(SQLiteDatabase _db) { _db.execSQL(CREATE_TABLE_USERS); _db.execSQL(CREATE_TABLE_COMPUTERS); } Is there somehting I am doing wrong during the creating, as the rest of the code (to read data) is exactly the same... but I can't figure it out. Please help!!! Thanks in advance, Neil --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---