SQLite No Such Table

__Jon__ · September 25th, 2010, 11:02 PM

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:

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?

vladimirov · September 26th, 2010, 07:47 AM

Can you post here a source code of NewDbHelper class?

__Jon__ · September 27th, 2010, 09:30 AM

Thanks for your reply. Thankfully just today I fixed the problem. Rather embrassing really, I put the wrong suffix onto the database name. Ooops.