Unable To Start Activity ,android.database.sqlite.SQLiteException: No Such Table, While Compiling: SELECT * FROM Table

I am getting this error and doing first time so any suggestions, why it is coming and how to resolve it. From this link i didnt get any help android.database.sqlite.SQLiteException

Solution 1:

I see in you have two primary keys in your CREATE_TABLE_TRACK so just remove one of those to solve the problem. like this :

//just removed one of ypur primary keys
String CREATE_TABLE_TRACK = "CREATE TABLE " + TABLE_TRACK + "("
                    + KEY_UIDTRACK + " INTEGER PRIMARY KEY," + KEY_DOCKETNO
                    + " INTEGER ," + KEY_DEALERNAME + " TEXT,"
                    + KEY_CUSTOMERNAME + " TEXT ," + KEY_PCS
                    + " INTEGER ," + KEY_DELIVERY_STATUS + " TEXT ,"
                    + KEY_REMARKS + " TEXT ," + KEY_CREATED_AT_TRACK + " TEXT"
                    + ")";

as @Mike M said you have some syntax errors in your code. I fixed them too.