Android SQLiteException

Question

Here's my app, the AVD starts up but when I try to open the app I get a message

"Your App has stopped working unfortunately"

This is my Logcat details:

Caused by: android.database.sqlite.SQLiteException: near "TABLEproducts": syntax error (code 1): , while compiling: CREATE TABLEproducts(_idINTEGER PRIMARY KEY AUTOINCREMENTproductnameTEXT);

Any help is more than appreciated.

Here is the Code:

public class MyDB extends SQLiteOpenHelper {

private static final int DATABASE_VERSION = 1;
private static final String DATABASE_NAME = "store.db";
public static final String  TABLE_PRODUCTS = "products";
public static final String  COLUMN_ID = "_id";
public static final String  COLUMN_PRODUCTNAME = "productname";


public MyDB(Context context, String name, SQLiteDatabase.CursorFactory   factory, int version) {
super(context, DATABASE_NAME, factory, DATABASE_VERSION);
}

@Override
public void onCreate(SQLiteDatabase db) {
 String query = "CREATE TABLE" + TABLE_PRODUCTS + "(" +
        COLUMN_ID + "INTEGER PRIMARY KEY AUTOINCREMENT" +
        COLUMN_PRODUCTNAME + "TEXT" +
                 ");";
 db.execSQL(query);
}

Renjith · Accepted Answer · 2015-07-21 16:33:31Z

2

Put space after TABLE like "CREATE TABLE " and also after every column name.

String query = "CREATE TABLE " + TABLE_PRODUCTS + "(" +
        COLUMN_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " +
        COLUMN_PRODUCTNAME + " TEXT " +
                 ");";

answered Jul 21, 2015 at 16:33

Renjith

3,28421 silver badges39 bronze badges

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

2 Comments

Veeresh Over a year ago

Caused by: android.database.sqlite.SQLiteException: near "productnameTEXT": syntax error (code 1): , while compiling: CREATE TABLE products( _idINTEGER PRIMARY KEY AUTOINCREMENT productnameTEXT );

Renjith Over a year ago

try the query I provided

Collectives™ on Stack Overflow

Android SQLiteException

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related