Error In Sqlite
I'm creating a SQLite, I added 4 columns into my table, but when adding the fifth column 'productadd' cannot not be found. What's the problem here? Sorry, I'm really new to sqlite
Solution 1:
There is a missing space here:
+ "productprice"
+ "TEXT,"
Change to :
+ "productprice "
+ "TEXT,"
Solution 2:
db.execSQL("CREATE TABLE if not exists producttable(id INTEGER PRIMARY KEY AUTOINCREMENT,"
+ " productidno"
+ " TEXT ,"
+ " productname"
+ " TEXT,"
+ " productprice"
+ " TEXT,"
+ " productdest"
+" TEXT)");
Post a Comment for "Error In Sqlite"