N
N
Neonoviiwolf2017-09-04 01:01:23
Java
Neonoviiwolf, 2017-09-04 01:01:23

Why are default values ​​not populated in SQLite?

Good.
I don’t understand, there is such a block, when adding a record, only the filling of the line is entered, and the rest remain empty. If you change REAL to INTEGER, then the default entries appear

db.execSQL("CREATE TABLE " + TABLE_PRODUCT_VALUE
                + " ( _id INTEGER primary key autoincrement, "
                + colID + " INTEGER, "
                + colA + " REAL NOT NULL DEFAULT 0.0, "
                + colB + " REAL NOT NULL DEFAULT 0.0, "
                + colC + " REAL NOT NULL DEFAULT 0.0, "
                + colD + " REAL NOT NULL DEFAULT 0.0, "
                + colF + " REAL NOT NULL DEFAULT 0.0);");

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question