I'm trying to opena database and perform searches of it. It's a prebuilt SQLite DB which I put into assets directory and used the SQLiteOpenHelper class to open it up.
Now I want to perform querys but I keep getting No Such Table errors, and after trying any number of permutations of searches I am at a loss. I don't know what is wrong.
I prefer doing rawQuery since I know a little SQL anyway. This is what I did, after opening the DB:
Anyone had similar problems or know what to do?
Now I want to perform querys but I keep getting No Such Table errors, and after trying any number of permutations of searches I am at a loss. I don't know what is wrong.
I prefer doing rawQuery since I know a little SQL anyway. This is what I did, after opening the DB:
Code:
SQLiteDatabase MyDb = NewDbHelper.getReadableDatabase();
String selection = "SELECT Wordlink FROM Questions WHERE Level = 3";
Cursor c = MyDb.rawQuery(selection,null);
Anyone had similar problems or know what to do?