I don't see that you have CREATE_TABLE_COMPUTERS defined.
--
Jack Ha
Open Source Development Center
・T・ ・ ・Mobile・ stick together
The views, opinions and statements in this email are those of
the author solely in their individual capacity, and do not
necessarily represent those of T-Mobile USA, Inc.
On Jul 30, 8:47 am, Skeniver <skeni...@gmail.com> wrote:
> 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
-~----------~----~----~----~------~----~------~--~---
