Data's won't reload after DB change

[snowboarderz69]

Hello everyone,

I have a little problem with my Sqlite app. I'm showing on my main screen some text from the table "x" in the field "y". Now i'm trying to show text from the same table but from a different field wich is not created. I create it and add some text, then test it on the iPhone simulator and I get the error :

No such column : "nameOfMyTab"..

Do I have to do something to let xCode know that I modified my database ?
p.s (I'm not creating an editable copy of my DB so that can't be the prob)

Thanks alot !

[Oliver Drobnik]

Originally Posted by snowboarderz69

Hello everyone,

I have a little problem with my Sqlite app. I'm showing on my main screen some text from the table "x" in the field "y". Now i'm trying to show text from the same table but from a different field wich is not created. I create it and add some text, then test it on the iPhone simulator and I get the error :

No such column : "nameOfMyTab"..

Do I have to do something to let xCode know that I modified my database ?
p.s (I'm not creating an editable copy of my DB so that can't be the prob)

Thanks alot !

If you're using CoreCata you have to update the schema to match.

[snowboarderz69]

Sadly I am not using core data

Anyone else ? It's for a school project and it have to be done for tomorrow

[JasonR]

There's nothing special that needs to be done for xCode to see the new field. Are you sure it's being created successfully?

[snowboarderz69]

It's supposed to.. I open my db by clicking the one I see in xCode and I see the new field.. It's very strange =(

[JasonR]

Maybe you need to post the code you are using to read the DB. Could be something you are overlooking.

[snowboarderz69]

I initialize my database with :

// Ouvre la base de donnée et récupère les clefs primaire de la table principal
- (void)initializeDatabase {
    NSMutableArray *todoArray = [[NSMutableArray alloc] init];
    self.todos = todoArray;
    [todoArray release];
    NSArray *paths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES);
    NSString *documentsDirectory = [paths objectAtIndex:0];
    NSString *path = [documentsDirectory stringByAppendingPathComponent:@"todo.sqlite"];
    // Ouvre la base de donnée 
    if (sqlite3_open([path UTF8String], &database) == SQLITE_OK) {
        // Trouve les clefs primaires
        const char *sql = "SELECT pk FROM todo";
        sqlite3_stmt *statement;
        if (sqlite3_prepare_v2(database, sql, -1, &statement, NULL) == SQLITE_OK) {
            while (sqlite3_step(statement) == SQLITE_ROW) {
                int primaryKey = sqlite3_column_int(statement, 0);
                Todo *td = [[Todo alloc] initWithPrimaryKey:primaryKey database:database];
				
                [todos addObject:td];
                [td release];
            }
        }
        sqlite3_finalize(statement);
    } else {
        sqlite3_close(database);
        NSAssert1(0, @"Failed to open database with message '%s'.", sqlite3_errmsg(database));
    }
}

I init my view with this code :

//Initie la vue principal (la liste des étapes) avec les informations de la BD
- (id)initWithPrimaryKey:(NSInteger)pk database:(sqlite3 *)db {
	
	if (self = [super init]) {
        primaryKey = pk;
        database = db;
        if (init_statement == nil) {
            const char *sql = "SELECT text,complete,destination FROM todo WHERE pk=?";
            if (sqlite3_prepare_v2(database, sql, -1, &init_statement, NULL) != SQLITE_OK) {
                NSAssert1(0, @"Error: failed to prepare statement with message '%s'.", sqlite3_errmsg(database));
            }
        }
        sqlite3_bind_int(init_statement, 1, primaryKey);
        if (sqlite3_step(init_statement) == SQLITE_ROW) {
            self.text = [NSString stringWithUTF8String:(char *)sqlite3_column_text(init_statement, 0)];
			self.destination = [NSString stringWithUTF8String:(char *)sqlite3_column_text(init_statement,2)];
			self.status = sqlite3_column_int(init_statement,1);
        } else {
            self.text = @"Aucun itinéraire";
        }
        sqlite3_reset(init_statement);
    }
    return self;
}

The actual field in problem is "destination"..

is there anything wrong ?
Thanks

[snowboarderz69]

Gotta turn in my project in 12 hours and it won't work. I really tryed everything it's so strange :s

[JasonR]

Everything looks fine from here. Could you have a simple misspelling of the column name "destination" in the actual database? I think it might be case sensitive, so "Destination" would not match.

[snowboarderz69]

Everything in the Database is fine. There must be something wrong =/

[iisword]

Originally Posted by snowboarderz69

Everything in the Database is fine. There must be something wrong =/

For the tableview class, try something like this:

- (void)viewDidAppear:(BOOL)animated 
{
    [super viewDidAppear:animated];
	
	[self.tableView reloadData];
}

I forgot to reload the data again when new data is in the table.

[snowboarderz69]

Damn I just found out what was going on... My select/update/insert/delete statements where STATIC variable so they were keeping the old data's. I should have saw them before !

Thanks alot everyone for your help, I love how people on this forum help each/other, it's nice