• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Cant read second table from same sqlite database iphone
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Cant read second table from same sqlite database iphone


  • Subject: Re: Cant read second table from same sqlite database iphone
  • From: charisse napeÿfffff1as <email@hidden>
  • Date: Sat, 10 Apr 2010 18:42:07 -0700 (PDT)

I was able to successfully retrieve data on the first table. But I can't seem to retrieve from the second table. I know it has data inside it because I used an SQLite Browser to view the data. I also tried performing queries there and it worked fine. Only when I used the queries in the code that it doesn't work.

Below is the code writing the database in the Users/Documents folder for Iphone

- (void) createDatabaseIfNeeded
{
    NSError * error;

    //gets access to the file system
    NSFileManager * fileManager = [NSFileManager defaultManager];

    // gets the complete users document directory path
    NSArray * paths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES);

    // gets the first path in the array
    NSString * documentsDirectory = [paths objectAtIndex:0];

    // create the complete path for the database file
    NSString * databasePath = [documentsDirectory stringByAppendingString:@"/Database.sql"];

    DebugLog("databasePath = %s\n",[databasePath UTF8String]);

    // check if file exists or not
    BOOL success = [fileManager fileExistsAtPath:databasePath];

    if (success) return;

    // the database does not exist so copy it in the users documents directory
    NSString * dbPath = [[[NSBundle mainBundle] resourcePath] stringByAppendingPathComponent:@"/Database.sql"];

    DebugLog("dbpath is %s\n",[dbPath UTF8String]);

    //copy the database file to ther users docuement directory

    success = [fileManager copyItemAtPath:dbPath toPath:databasePath error:&error];

    if (!success)
        NSAssert(0,@"Failed to copy Database!\n");
}





________________________________
From: Ben Trumbull <email@hidden>
To: email@hidden
Cc: Cocoa dev <email@hidden>
Sent: Sunday, April 11, 2010 9:27:46
Subject: re: Cant read second table from same sqlite database iphone

> Hello All,
>
> I am having trouble reading the second table from my database because it returns nothing even if there is data inside it.

How do you know it has data inside it ?  A common mistake is to try to write to databases in the read only part of an application's sandbox on the iphone.  Where in the sandbox is the database ?

> - (NSMutableArray*) getProvinces
> {
>    NSMutableArray * data = [[NSMutableArray alloc] init];
>    const char * sql = "SELECT * FROM Provinces";
>    sqlite3_stmt * statement;
>
>    //prepare the select statement
>    int returnValue = sqlite3_prepare_v2(mDatabase, sql, -1, &statement, NULL);
>
>    DebugLog("return value = %d\n",returnValue);
>
>    if (returnValue == SQLITE_OK)
>    {
>        //sqlite3_bind_int(statement, 1, regionID);
>        //loop all the rows returned by the query
>        while (sqlite3_step(statement) == SQLITE_ROW)
>        {


You don't check the return codes here properly.  sqlite3_prepare_v2() can return SQLITE_BUSY, or SQLITE_SCHEMA, or SQLITE_MISUSE.  More importantly, you don't check if sqlite3_step() returns SQLITE_DONE which would indicate that you have 0 rows in this table.

- Ben


      Get your new Email address!
Grab the Email name you&#39;ve always wanted before someone else does!
http://mail.promotions.yahoo.com/newdomains/aa/
_______________________________________________

Cocoa-dev mailing list (email@hidden)

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:

This email sent to email@hidden

  • Follow-Ups:
    • Re: Cant read second table from same sqlite database iphone
      • From: Ben Trumbull <email@hidden>
References: 
 >re: Cant read second table from same sqlite database iphone (From: Ben Trumbull <email@hidden>)

  • Prev by Date: re: Cant read second table from same sqlite database iphone
  • Next by Date: QCRenderer.... how do you do that?
  • Previous by thread: re: Cant read second table from same sqlite database iphone
  • Next by thread: Re: Cant read second table from same sqlite database iphone
  • Index(es):
    • Date
    • Thread