jeudi 21 avril 2016

Autoincrement not working on ID

I'm having some trouble getting my autoincrement to work in SQL in my android app.

public static final String TABLE_NAME = "collections";
public static final String COLUMN_ID = "_id";
public static final String COLUMN_TITLE = "title";
public static final String CREATE_STATEMENT = "CREATE TABLE " + TABLE_NAME +
        "(" +
        COLUMN_ID + " INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, " +
        COLUMN_TITLE + " TEXT NOT NULL" + ")";

Are there any major problems with the create statement that could cause this?

Aucun commentaire:

Enregistrer un commentaire