Autoincremet in SQLite is not working on Android

Question

Autoincremet in SQLite is not working on Android

Navigation

#1 by (0 votes)

2

Autoincrement is not working on my tables in SQLite.

Table:

db.execSQL("create table usuario(_idUsuario integer primary key autoincrement, nome text not null, email text not null, senha text not null)");

Insert:

public String insertUsuario(Usuario usuario) {
    db = dbHelper.getWritableDatabase();
    long resultado;

    ContentValues values = new ContentValues();

    values.put("nome", usuario.getNome());
    values.put("email", usuario.getEmail());
    values.put("senha", usuario.getSenha());

    resultado = db.insert("usuario", null, values);

    if (resultado == -1) {
        return "Usuário não foi criado!";
    } else {
        return "Usuário foi criado com sucesso";
    }
}

I enter the values through the code below:

 usuario.setNome(cadNome);
 usuario.setEmail(cadEmail);
 usuario.setSenha(cadSenha);
 DBControle db = new DBControle(getApplicationContext());

 String a = db.insertUsuario(usuario);

Any user that is created is with id = 0. What am I doing wrong?

android sqlite

asked by anonymous 16.11.2017 / 17:59

1 answer

Changing Fullcalendar operation Simulate a click, like sharing a link to Google+ without clicking

score 0 · Answer 1

Create the id column only as _id. Automatically autoincrement is done Something like:

db.execSQL("create table usuario(_id integer primary key, nome text not null, email text not null, senha text not null)");