Sqlite Database Error duplicate column name

Question

Error Code : 1 (SQLITE_ERROR) Caused By : SQL(query) error or missing database.
    (duplicate column name: Floor (code 1)
while compiling: 
CREATE TABLE LocalizationInfo(_item INTEGER PRIMARY KEY, idINT,Floor TEXT, Floor HeightTEXT, Adress TEXT ,LatitudeTEXT, LongitudeTEXT, Altitude TEXT,Pressure TEXT) 

I tried to save my data i.e. Floor,Floor height, GPS data and Adress which was obtained from another activity to another which implements the SQLite data for saving,loading,editting and deletion. I am always receiving this error message when i try to add the data from the other activity to the database by clicking the list or post button which directs the user to the database.

Answer 1

try not to put space between Floor Height, if you want you can do _ ie. Floor_Height TEXT

Answer 2

I think your problem caused by using whitespace for your colum name Floor Height. It would be good idea that you should use underscore instead of whitespace for column names. You can define your column names like floor, floor_height, gps_data and address.