could not prepare statemnt: no such table: test "SQLITE"

hosam · 01-09-2009, 04:55 PM

Hello,

I have a very very weird problem with SQLITE today. I have a database with the name "hosam.sqlite" and it have one table called test.

- From the command line I insert a new row in the test table

- In Resources I added the file and checked copy to project if needed

Now when I issue a select command on the database, I get an error that the table doesn't exist in my database!.

I made clean all targets and rebuilt but still the same problem that for some reason the path to the database is wrong so the phone makes its own database

Any ideas or hints?

thanks,

Hosam

jmac1074 · 01-09-2009, 07:44 PM

how do you get the path to the database?

This is the easiest way:

Code:

[[NSBundle mainBundle]pathForResource:@"hosam"extension:@"sqlite"];

Jmac

hosam · 01-09-2009, 07:57 PM

Thanks a lot for your reply but now I get an exception

*** -[NSBundle pathForResource:extension:]: unrecognized selector sent to instance 0x50b1d0
2009-01-10 02:53:12.557 [37340:20b] *** Terminating app due to uncaught exception 'NSInvalidArgumentException', reason: '*** -[NSBundle pathForResource:extension:]: unrecognized selector sent to instance 0x50b1d0'

The way I was doing it before was like that

Code:

NSArray *paths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES);
  NSString *documentsDirectory = [paths objectAtIndex:0];
 /NSString *path = [documentsDirectory stringByAppendingPathComponent:@"hosam.sqlite"];

and the call to open the database is

Code:

   if (sqlite3_open([path UTF8String], &database) == SQLITE_OK) {

hosam.sqlite is inside the resources folder as well as in the project folder

jmac1074 · 01-09-2009, 10:33 PM

sorry, i totally spaced. I spelled the method wrong.

Its actually:

Code:

[[NSBundle mainBundle]pathForResource:@"hosam"ofType:@"sqlite"];

that will work. the problem is that right now you are looking for it in the documents directory which is not the same thing as the project directory/bundle.

Jmac

hosam · 01-10-2009, 08:45 AM

Many thanks

it works now

NewToMacAndIphone · 04-25-2009, 01:50 AM

Thank. This is helpful and resolved my problem.

I was running into the same issue and was suspecting that my sqlitedb file is not getting copied to the "Documents" directory on the device. For the same reason I didn't add it to the resource bundle.

Q1: How do you copy existing document to the "<HOME>/Documents" folder on the device? Or is it only for the documents that get created by the app on the device?

Q2: Is it recommended to have sqldb as part of the resource bundle assuming it will grow over a period of time?

int3rc3pt0r · 04-21-2010, 05:27 AM

Quote:

Originally Posted by jmac1074

sorry, i totally spaced. I spelled the method wrong.

Its actually:

Code:

[[NSBundle mainBundle]pathForResource:@"hosam"ofType:@"sqlite"];

that will work. the problem is that right now you are looking for it in the documents directory which is not the same thing as the project directory/bundle.

Jmac

Hey this code worked for me thanks ...
I am using a Wrapper from : Objective-C: SQLite Wrapper : Th30z – Coding on the Fly

will this cause any issue ahead ???

Aspgod · 01-09-2012, 09:03 AM

Quote:

Originally Posted by jmac1074

sorry, i totally spaced. I spelled the method wrong.

Its actually:

Code:

[[NSBundle mainBundle]pathForResource:@"hosam"ofType:@"sqlite"];

that will work. the problem is that right now you are looking for it in the documents directory which is not the same thing as the project directory/bundle.

Jmac

It works !!. Thank you very much.