Android Sqlite database column defined in Create table script but not creating on table

Question

I have a the below table script:

"CREATE TABLE " + TABLE_XXX + "("
                    + XXX_ID + " INTEGER PRIMARY KEY,"
                    + XXX_ITEM_NO + "TEXT,"
                    + XXX_DETAILS +"TEXT,"
                    + XXX_EXP_DATE + "TEXT,"
                    + XXX_IS_OK +"INTEGER, "
                    + XXX_CODE + "TEXT"
                    + ")";

But when I'm going to insert data getting the error , TABLE_XXX has no column named XXX_IS_OK.

how to overcome it. Thanks!

Have you incremented your database version number / cleaned up old database files so that onUpgrade() or onCreate() are called? — laalto
– laalto, Commented Sep 10, 2013 at 11:50
there should be space between variable and column constraints like XXX_ITEM_NO + " TEXT,". If no space, then string will be merged, Table will not get created throwing an exception.. — CRUSADER
– CRUSADER, Commented Sep 10, 2013 at 11:52

CRUSADER · Accepted Answer · 2013-09-10 11:54:28Z

1

You need give some spaces on the code. Before the quotation marks.

"CREATE TABLE " + TABLE_XXX + "("   
+ XXX_ID + " INTEGER PRIMARY KEY, "   
+ XXX_ITEM_NO + " TEXT, "     
+ XXX_DETAILS +" TEXT, "   
+ XXX_EXP_DATE + " TEXT, "   
+ XXX_IS_OK + " INTEGER, "
+ XXX_CODE + " TEXT "   
+ ")";

edited Sep 10, 2013 at 11:54

CRUSADER

5,4723 gold badges30 silver badges66 bronze badges

answered Sep 10, 2013 at 11:53

Miguel Maciel

1768 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Andi Krusch · Accepted Answer · 2013-09-10 11:52:42Z

1

There are missing whitespaces in your statement.

+ XXX_IS_OK +"INTEGER, "

should be:

+ XXX_IS_OK +" INTEGER, "

answered Sep 10, 2013 at 11:52

Andi Krusch

1,3838 silver badges6 bronze badges

Collectives™ on Stack Overflow

Android Sqlite database column defined in Create table script but not creating on table

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related