Error As "no Such Table" While Inserting Data In To Table

Getting Error as NO such table,Table is not creating,Please help me with your answers.I think error is database.java file.So I uploaded it.In inserting values I am not changing fie

Solution 1:

Rectify Your Query . Aware from Blank Space and Single-Double Quote .

"CREATE TABLE " + TABLE_NAME + " ("
                    + CODE + " INTEGER AUTOINCREMENT ," 
                    + NAME + " TEXT PRIMARY KEY ,"
                    + TYPE + " TEXT ,"
                    + ADD1 + " TEXT ,"
                    + ADD2 + " TEXT ,"
                    + CITY + " TEXT ,"
                    + COUNTRY + " TEXT ,"
                    + PHONENO + " TEXT ,"
                    + CONTACTPERSON + " TEXT ,"
                    + EMAILID + " VARCHAR(50) ,"
                    + FAX + " REAL ,"
                    + TNO + " REAL ,"
                    + CSTNO + " REAL ,"
                    + GSTNO + " REAL ,"
                    + SERVICENO + " REAL" + ")";

FYI

Use INTEGER PRIMARY KEY AUTOINCREMENT in CODEField

 + CODE + " INTEGER PRIMARY KEY AUTOINCREMENT ," 
 + NAME + " TEXT ,"

Solution 2:

instead of AUTOINCREMENT Use AUTO_INCREMENT

Solution 3:

Try to add query like this:

String TABLE="CREATE TABLE "+ TABLE_NAME + "("
                + CODE + " INTEGER AUTOINCREMENT,"
                + NAME + " TEXT PRIMARY KEY ,"
                + TYPE + " TEXT,"
                + ADD1 + " TEXT,"
                + ADD2 + " TEXT,"
                + CITY + " TEXT,"
                + COUNTRY + " TEXT,"
                + PHONENO + " TEXT,"
                + CONTACTPERSON + " TEXT,"
                + EMAILID + " VARCHAR(50),"
                + FAX + " REAL,"
                + TNO + " REAL,"
                + CSTNO + " REAL,"
                + GSTNO+ " REAL,"                                                                                                                          
                + SERVICENO +" REAL" +")";

        db.execSQL(TABLE);

always care about white space and ending close bracts like above. hope this will help you.