no such table found android

Question

I am creating database for an application ,Here is my code giving me error no such table found where is the problem please help

protected static final String player = ("CREATE TABLE " + table_player
            + " (" + player_id + " INTEGER PRIMARY KEY AUTOINCREMENT, "
            + player_name + " TEXT, " + player_dob + "INTEGER" + player_gender + " TEXT);");

in oncreatdatabase()

db.execSQL(player);

insert method:

public long insert_Place(  )//, String _Placealti)
    {    
        try
        {
            SQLiteDatabase db= this.getWritableDatabase();
            ContentValues contentValues = new ContentValues();  
            contentValues.put(player_name, "name"); 
            contentValues.put(player_dob,  "123");
            contentValues.put(player_gender, "male");

            return db.insert(table_player, null, contentValues);
        }
        catch(Exception ex)
        {
            Log.d("Insert:  insert_Place",ex.toString());
        }
        return 0;
    }

There are SQL syntax problems but the error you're seeing suggests the SQL has not even been run in the first place. Uninstall your app first and fix the missing whitespace and commas in the `CREATE TABLE` (to get rid of the "no such column" errors). — laalto, Sep 24 '14 at 11:27
its always best to test out your sql statements before embeddeding them in your application. or atleast Log.v(TAG,"sql = " + player); from within your app to ensure the sql is valid — Hector, Sep 24 '14 at 11:30

M D · Answer 1 · 2014-09-24T11:31:18.313

Missed , after INTEGER and also add one space between Column Name and Column Type

+ " INTEGER " + player_gender + " + " TEXT);")//  Missed , after INTEGER and add one space before INTEGER

Correct:

protected static final String player = ("CREATE TABLE " + table_player
        + " (" + player_id + " INTEGER PRIMARY KEY AUTOINCREMENT, "
        + player_name + " TEXT, " + player_dob + " INTEGER," + player_gender + " TEXT);");

That's why your table is not crated and you got NO Such table found Exception

score 1 · Answer 2 · answered Sep 24 '14 at 11:28

1

The table isn't being created due to a syntax error:

player_name + " TEXT, " + player_dob + "INTEGER" + player_gender + " TEXT);"

should be

player_name + " TEXT, " + player_dob + " INTEGER, " + player_gender + " TEXT);"

answered Sep 24 '14 at 11:28

Phantômaxx

37,901
21
84
115

score 1 · Answer 3 · answered Sep 24 '14 at 11:32

//write to this

String player = "CREATE TABLE IF NOT EXISTS "
            + table_player + "(" + player_id
                      + " integer primary key , " + player_name
                      + " text ,"+ player_dob+" integer,"+player_gender+" text);";

no such table found android

3 Answers3

Correct: