[Solved] error as “No such table” while inserting data in to table

by


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 CODE Field

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

4

solved error as “No such table” while inserting data in to table