CODEWITHSUNDEEP
androidsqliteandroid-sqlite
Rafael Antonio Pimienta López
Rafael Antonio Pimienta López

Reputation: 43

Field _id is always 0

I create a table with 3 fields (_id, nombre, telefono).

@Override
public void onCreate(SQLiteDatabase db) {
    String sql = "CREATE TABLE "+TABLE_NAME+" ("+
            KEY_ID +" INTEGER PRYMARY KEY, "+
            KEY_NOMBRE +" TEXT, "+
            KEY_TELEFONO +" TEXT);";

    db.execSQL(sql);

}
public void add(String nombre, String telefono, SQLiteDatabase database) {
    ContentValues values = new ContentValues();
    values.put(KEY_NOMBRE,nombre);
    values.put(KEY_TELEFONO,telefono);

    database.insert(TABLE_NAME, null, values);

}

When I insert a record the _id always takes the value (0).

Upvotes: 1

Views: 644

Answers (1)

user3629714
user3629714

Reputation:

You have a typo in the CREATE TABLE string: "PRYMARY" instead of "PRIMARY". Change it to:

  String sql = "CREATE TABLE "+TABLE_NAME+" ("+
            KEY_ID +" INTEGER PRIMARY KEY, "+
            KEY_NOMBRE +" TEXT, "+
            KEY_TELEFONO +" TEXT);";

Upvotes: 2

Related Questions