can not Creating tables in sqlite database on android

Question

I can not create a table. It shows that the database is created and I can also insert a row, but the table is not created.

public class DatabaseOperations extends SQLiteOpenHelper {

public static final int Database_version = 2;

public static final String Tag = DatabaseOperations.class.getSimpleName();

private static final String SQL_CREATE_ENTRIES =
        "CREATE TABLE " + TableData.TableInfo.TABLE_NAME + " (" +
                TableData.TableInfo.USER_ID + " INTEGER PRIMARY KEY," +
                TableData.TableInfo.USER_PASS +" TEXT "+ "," +
                TableData.TableInfo.USER_EMAIL +" TEXT "+ ");";

public DatabaseOperations(Context context) {
super(context, TableData.TableInfo.DATABASE_NAME, null,Database_version);
    Log.d("Tag", "Database created");
}

@Override
public void onCreate(SQLiteDatabase sdb) {
    sdb.execSQL(SQL_CREATE_ENTRIES);
    Log.d("Tag", "Table created");

}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

}

public void putInformation(DatabaseOperations drop, String name, String   pass, String email) {
    SQLiteDatabase SQ = drop.getWritableDatabase();
    ContentValues cv = new ContentValues();
    cv.put(TableData.TableInfo.USER_ID, name);
    cv.put(TableData.TableInfo.USER_PASS, pass);
    cv.put(TableData.TableInfo.USER_EMAIL, email);
    long k = SQ.insert(TableData.TableInfo.TABLE_NAME, null, cv);
    Log.d("Tag", "inert a row");
 }

public Cursor getInformation(DatabaseOperations dop) {
    SQLiteDatabase SQ = dop.getReadableDatabase();
    String[] coloumns = {TableData.TableInfo.USER_ID,  TableData.TableInfo.USER_PASS, TableData.TableInfo.USER_EMAIL};
    Cursor CR = SQ.query(TableData.TableInfo.TABLE_NAME, coloumns, null, null, null, null, null);
    return CR;
}
}

your sql staement has a mistake there ");";. remove the first ; — Aelop
– Aelop, Commented Dec 14, 2016 at 9:47
I don't think it's the problem. The first semicolon is there to show the end of the SQL Statement, so it's right. — Elcan
– Elcan, Commented Dec 14, 2016 at 9:49
The ; is only useless in a SQLite statement (because no multiple statements will be processed), but not harmful. — Phantômaxx
– Phantômaxx, Commented Dec 14, 2016 at 9:51

Community · Accepted Answer · 2017-05-23 12:30:32Z

1

You're missing a , between USER_EMAIL and USER_PASS columns in the CREATE TABLE.

After adding it you can uninstall your app to recreate the database. When is SQLiteOpenHelper onCreate() / onUpgrade() run?

edited May 23, 2017 at 12:30

CommunityBot

11 silver badge

answered Dec 14, 2016 at 10:10

laalto

153k68 gold badges293 silver badges306 bronze badges

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

Comments

prsandroid · Accepted Answer · 2016-12-14 10:35:32Z

0

You miss comma in USER PASS type.Uninstall the application and install it again each time you add something new to sqlite database because the table structure has been changed.So you need to reinstall the new application .

The code should be like this

private static final String SQL_CREATE_ENTRIES = "CREATE TABLE " + TableData.TableInfo.TABLE_NAME + " (" + TableData.TableInfo.USER_ID + " INTEGER PRIMARY KEY," + TableData.TableInfo.USER_PASS +" TEXT ,"+ "," + TableData.TableInfo.USER_EMAIL +" TEXT "+ ")";

answered Dec 14, 2016 at 10:35

prsandroid

882 silver badges10 bronze badges

Collectives™ on Stack Overflow

can not Creating tables in sqlite database on android

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