Use adb logcat, DDMS, or the DDMS perspective in Eclipse to examine LogCat and look at the stack trace associated with your exception.
Your UNIQUE clause is incorrect. At minimum, the datatype needs to come first. On Wed, Feb 23, 2011 at 10:35 AM, Abhilash baddam <[email protected]> wrote: > I used like that, but i am getting exception.../? > myDB.execSQL("CREATE TABLE IF NOT EXISTS bikes_list(_id INTEGER PRIMARY KEY > AUTOINCREMENT, name UNIQUE VARCHAR , availablebikes INT, slots INT,status > VARCHAR);"); > > > On Wed, Feb 23, 2011 at 8:12 PM, Mark Murphy <[email protected]> > wrote: >> >> 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 > > -- > 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
