Go Back   Android Forums > Android Development > Application Development
Application Development Dev lounge for our application developers.

test: Reply
 
LinkBack Thread Tools
Old September 25th, 2010, 11:02 PM   #1 (permalink)
Junior Member
Thread Author (OP)
 
Join Date: Aug 2010
Posts: 15
 
Device(s):
Carrier: Not Provided

Thanks: 0
Thanked 0 Times in 0 Posts
Default 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:
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?

Advertisements
__Jon__ is offline  
Reply With Quote
sponsored links
Old September 26th, 2010, 07:47 AM   #2 (permalink)
Junior Member
 
Join Date: Apr 2010
Posts: 17
 
Device(s):
Carrier: Not Provided

Thanks: 12
Thanked 2 Times in 2 Posts
Default

Can you post here a source code of NewDbHelper class?
vladimirov is offline  
Reply With Quote
Old September 27th, 2010, 09:30 AM   #3 (permalink)
Junior Member
Thread Author (OP)
 
Join Date: Aug 2010
Posts: 15
 
Device(s):
Carrier: Not Provided

Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for your reply. Thankfully just today I fixed the problem. Rather embrassing really, I put the wrong suffix onto the database name. Ooops.
__Jon__ is offline  
Reply With Quote
Reply


Go Back   Android Forums > Android Development > Application Development
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -5. The time now is 06:14 PM.
Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.