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 Beginners" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/android-beginners?hl=en
-~----------~----~----~----~------~----~------~--~---
