In my android app, I have used SQLite database in the initial versions. I need to create a new table now in the app. I have given create statement in onCreate() and onUpgrate(), but both are not wroking and I am getting the error:
android.database.sqlite.SQLiteException: no such table
I tried, try...catch() which is also not working. Please suggest me a solution.
By searching the error line you can find other same solved questions on stackoverflow.
take a look at: problem about sqlite database, no such table:
There might be a reason that your table is already created.... try a new test app with this code (worked for me)
make a Test app with only one button which create a table
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
Button btn = (Button) findViewById(R.id.button1);
btn.setOnClickListener(new View.OnClickListener(){
@Override
public void onClick(View v) {
SQLiteDatabase objConnection=openOrCreateDatabase("database_name",MODE_PRIVATE,null);
objConnection.execSQL("Create Table IF NOT EXISTS table_name(id INTEGER primary Key AUTOINCREMENT, name Varchar(200))");
objConnection.close();
Toast.makeText(getApplicationContext(), "db created", Toast.LENGTH_SHORT).show();
}
});
}
