Sqlite column keeps combining the column name and the data type as the final column name

Question

My column name for the sqlite database is "name" but when I go to get data from the database the column name seems to be "nameTEXT" even though there's a space between name and TEXT in my SQL declaration for the table name.

EDIT-------

My Create Table statement is

String CREATE_INVENTORY_TABLE = "CREATE TABLE " + TABLE_INVENTORY + "(" + KEY_PD_NAME + " TEXT PRIMARY KEY," + KEY_PD_PRICE + " DECIMAL(10,2)," + KEY_PD_QUANTITY + " INTEGER" + ")";
   Log.d("SQL STATEMENT", CREATE_INVENTORY_TABLE);
    db.execSQL(CREATE_INVENTORY_TABLE);

Nothing shows up in the logs, I even went and deleted the created database from the device using DDMS but still no Log output. — DVNT, Aug 23 '16 at 04:50
Whoops, turns out I had to restart the emulator in order for the file deletion to take effect and run the Create method. Sorry for the time waster. — DVNT, Aug 23 '16 at 05:04

score 0 · Accepted Answer · answered Aug 23 '16 at 05:06

0

Deleted the old database files from the device and changed the onCreate method to use variables as column names and when I restarted the emulator the problem seemed to have gone away. Chalking this up to human error.

answered Aug 23 '16 at 05:06

DVNT

61
1
8

Sqlite column keeps combining the column name and the data type as the final column name

1 Answers1