₦airaland Forum

I'm getting this error: android.database.sqlite.SQLiteException: near "EXIST": syntax error: CREATE TABLE IF NOT EXIST EPuserStatus(Status VARCHAR);

See my code below...

SQLiteDatabase db = openOrCreateDatabase("ExamPoemsStatus", MODE_PRIVATE, null);

try {
db.execSQL("CREATE TABLE IF NOT EXIST EPuserStatus(Status VARCHAR);";
db.execSQL("INSERT INTO EPuserStatus Values('good');";

Cursor result = db.rawQuery("SELECT * FROM EPuserStatus", null);
result.moveToFirst();
String status = result.getString(1);




Toast.makeText (getBaseContext(), "Data: " +status.toString(), Toast.LENGTH_SHORT).show();

db.close();
}
catch (Exception e) {Toast.makeText (getBaseContext(), "Error: " +e.toString(), Toast.LENGTH_LONG).show();
}

It should be exists instead of exist (notice the "s" at the end).

nollyj:
It should be exists instead of exist (notice the "s" at the end).

OMG Thanks! God bless you. I've corrected it and it's working.