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
