Make the _ID AUTOINCREMENT and use a UNIQUE constraint on the name. On Wed, Feb 23, 2011 at 9:32 AM, Abhilash baddam <[email protected]> wrote: > Hi Mark, > What's the solution for my problem, i want the _id column should > have integer values and there should be increment. For the column name i > don't want to add duplicate values. Any alternate is there. > > On Wed, Feb 23, 2011 at 7:50 PM, Mark Murphy <[email protected]> > wrote: >> >> AUTOINCREMENT is only available on INTEGER PRIMARY KEY columns: >> >> http://sqlite.org/lang_createtable.html >> http://sqlite.org/autoinc.html >> >> On Wed, Feb 23, 2011 at 9:15 AM, Abhilash baddam >> <[email protected]> wrote: >> > 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 >> >> >> >> -- >> Mark Murphy (a Commons Guy) >> http://commonsware.com | http://github.com/commonsguy >> http://commonsware.com/blog | http://twitter.com/commonsguy >> >> Android App Developer Books: http://commonsware.com/books >> >> -- >> 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 > > -- > 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
-- Mark Murphy (a Commons Guy) http://commonsware.com | http://github.com/commonsguy http://commonsware.com/blog | http://twitter.com/commonsguy Android App Developer Books: http://commonsware.com/books -- 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
