Sqlitedatabase Error "sqlite: (1) Near ")": Syntax Error"

sqlite: (1) near ')': syntax error I don't understand, I thought (and still do) that I put every space (and ect.) needed maybe someone could help me? thanks for your time public cl

Solution 1:

Your issue is here CREATE TABLE SQL COMMAND

  + KEY_ID + " INTEGER PRIMARY KEY, " + KEY_REKORDAI + " TEXT," + " ) ";// remove semi column after TEXT 

Correct CREATE TABLE SQL COMMAND with below

StringCREATE_REKORDAI_TABLE="CREATE TABLE " + TABLE_REKORDAI + " ( " 
            + KEY_ID + " INTEGER PRIMARY KEY, " + KEY_REKORDAI + " TEXT" + " ) ";