Skip to content Skip to sidebar Skip to footer

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"