Android.database.sqlite.sqliteexception: Near "create_record_table"

I'm quite new to android programming and getting an error I couldn't figure out. I basicly wrote a code that let the user send his current coordinates to a local SQLite database. t

Solution 1:

The mistake you made is in the SQlite Activity's onCreate(SQLiteDatabase db) method. Your database query should look like below :

StringCREATE_RECORD_TABLE="CREATE TABLE RECORD ( " +
            "id INTEGER PRIMARY KEY AUTOINCREMENT, " + 
            "latitude TEXT NOT NULL, "+ 
            "longtitude TEXT NOT NULL, "+ 
            "accuracy TEXT NOT NULL, "+ 
            "time TEXT NOT NULL )"; 

For a full fledged example on Databases , refer Android official training page : http://developer.android.com/training/notepad/index.html

OR Codeproject : http://www.codeproject.com/Articles/524204/Simple-notepad-for-Android