It is a new morning. Same problem.

Here is my code:

NSArray *paths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES);
        NSString *documentsDirectory = [paths objectAtIndex:0];
NSString *path = [documentsDirectory stringByAppendingPathComponent:@"whatsfresh.sql"];
        
        int cntv = 0;
        int cntf = 0;
        
        ProduceItem *item=nil;
        if (sqlite3_open([path UTF8String], &database) == SQLITE_OK) {
        // Get the primary key for all books.
const char *sql = "SELECT type, subtype, name, id FROM ProduceItem ORDER BY name";
        sqlite3_stmt *statement;
if (sqlite3_prepare_v2(database, sql, -1, &statement, NULL) == SQLITE_OK) {



It does get to the second If statement so it did find the database. But then evidently it is not SQLITE_OK on my device in regards to that last if.

These so simple things always take the most time. 1000s of lines of code only to be stuck on this little database.

Thanks for all the help so far as I have eliminated some bad practices and even cleaned up some memory leaks.
Now to just get this to work on my device.

Thanks
James








On Feb 26, 2009, at 11:34 PM, Bill Bumgarner wrote:

On Feb 26, 2009, at 8:50 PM, James Cicenia wrote:
That is helping immensely. I have isolated it to the sqlite area. I can't believe
I didn't know you could debug on the device itself.. THANKS!

Though it works very bizarrely ... seems to step backwards sometimes?!

That'll most likely be because of the optimizer. If the compiler determines that statement B after statement A has no impact on A and would be faster to execute before A, it'll emit code that does exactly that [very simplistic example].

Anyway, onto reading more about sqlite in the device itself. It doesn't seem to return any rows. Do I have to do something special to get the data filled database
into the phone? It is in my resources group.

Did you make sure that the database is on the device where you expect it and really there (say, again, via NSFileManager's fileExistsAtPath:)?

b.bum


_______________________________________________

Cocoa-dev mailing list (Cocoa-dev@lists.apple.com)

Please do not post admin requests or moderator comments to the list.
Contact the moderators at cocoa-dev-admins(at)lists.apple.com

Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/cocoa-dev/archive%40mail-archive.com

This email sent to arch...@mail-archive.com

Reply via email to