I used like that, but i am getting exception.../?
m*yDB.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
