samedi 8 août 2015

having issue with Table creation in SQLite in Android

I'm having problem while table creation. Error says no such table even my query is correct and working fine I have checked it many times.

public class DatabaseOperations extends SQLiteOpenHelper {
public static final int database_version = 1;
public String CREATE_QUERY = "CREATE TABLE"+TableData.TABLE_NAME+"("+TableData.USER_NAME+" TEXT, "+TableData.USER_PASS+" TEXT);";
public DatabaseOperations(Context context) {
    super(context,TableData.DATABASE_NAME, null, database_version);
    Log.d("Database Operations", "Database Created");
}

@Override
public void onCreate(SQLiteDatabase db) {
    db.execSQL(CREATE_QUERY);
    Log.d("Database Operations", "Table Created");
}

@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

}

here is Logcat:

08-08 18:00:19.008    2036-2043/com.example.fani.sqlitetest W/art﹕ Suspending all threads took: 12.494ms
08-08 18:00:19.667    2036-2036/com.example.fani.sqlitetest D/Database Operations﹕ Database Created
08-08 18:00:19.673    2036-2036/com.example.fani.sqlitetest E/SQLiteLog﹕ (1) no such table: users_info
08-08 18:00:19.679    2036-2036/com.example.fani.sqlitetest E/SQLiteDatabase﹕ Error inserting user_pass=fani user_name=farhan
    android.database.sqlite.SQLiteException: no such table: users_info (code 1): , while compiling: INSERT INTO users_info(user_pass,user_name) VALUES (?,?)

Aucun commentaire:

Enregistrer un commentaire