Answer the question
In order to leave comments, you need to log in
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 questionAsk a Question
731 491 924 answers to any question