September 26th, 2010, 12:02 AM
Thread Author (OP)
Join Date: Aug 2010
Carrier: Not Provided
Thanked 0 Times in 0 Posts
SQLite No Such Table
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:
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?