I have onCreate method in DBHelper class
override fun onCreate(db: SQLiteDatabase){
val query = ("CREATE TABLE " + TABLE_NAME + " ("
+ ID_COL + " INTEGER PRIMARY KEY, " +
DATE_COL + " TEXT, " +
TIME_COL + " TEXT, " +
MAKE_COL + " TEXT, " + // MAKE AND MODEL COLUMN
PROBM_COL + " REAL, " + // PROBM - PROBABILITY OF MAKE
LPR_COL + " TEXT, " + // LPR - license plate recognition
PROBL_COL + " REAL, " + // PROBL - PROBABILITY OF ALPR
TC_COL + "TEXT)") //TC - time code
db.execSQL(query)
}
but when i try to call addData i get the next message
“table results has no column named timecode…”
I’ve checked my query, all whitespaces and etc. As I see, it’s ok
New contributor
Nazar Pankov is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1