Hi,
I am trying to create a table, like this
*myDB.execSQL("CREATE TABLE IF NOT EXISTS bikes_list(_id INTEGER
AUTOINCREMENT, name PRIMARY KEY VARCHAR , availablebikes INT, slots
INT,status VARCHAR);");*
*
*
but i am getting this Exception,
*
*
* *ERROR/AndroidRuntime(11141):
Caused by: android.database.sqlite.SQLiteException: near "AUTOINCREMENT":
syntax error: CREATE TABLE IF NOT EXISTS bikes_list(_id INTEGER
AUTOINCREMENT, name PRIMARY KEY VARCHAR , availablebikes INT, slots
INT,status VARCHAR);
what may be the reason..?
--
You received this message because you are subscribed to the Google
Groups "Android Developers" 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-developers?hl=en
