sqlite3 update text in uitextview

[yohliying]

had the sqlite statement ready for update..but i am confuse about getting text from uitextview and updating it..and i waned to update it using a uibutton..how do i carry on after creating the sql statement???kinda lost..any new solution is appreciated..

- (void) saveAllData {

if(isDirty) {

    if(updateStmt == nil) {
        const char *sql = "update Snap Set snapTitle = ?, snapDesc = ?, Where snapID = ?";
        if(sqlite3_prepare_v2(database, sql, -1, &updateStmt, NULL) != SQLITE_OK)
            NSAssert1(0, @"Error while creating update statement. '%s'", sqlite3_errmsg(database));
    }

    sqlite3_bind_text(updateStmt, 1, [snapTitle UTF8String], -1, SQLITE_TRANSIENT);
    sqlite3_bind_text(updateStmt, 2, [snapDescription UTF8String], -2, SQLITE_TRANSIENT);
    sqlite3_bind_int(updateStmt, 3, snapID);
        if(SQLITE_DONE != sqlite3_step(updateStmt))
        NSAssert1(0, @"Error while updating. '%s'", sqlite3_errmsg(database));

    sqlite3_reset(updateStmt);

    isDirty = NO;
}

//Reclaim all memory here.
[snapTitle release];
snapTitle = nil;
[snapDescription release];
snapDescription = nil;

//isDetailViewHydrated = NO;
}

[brian]

Where have u assigned the text from textview. Is snapTitle and snapDesc textviews?

If so, then you have to use "snapTitle.text" instead of "snapTitle".

[yohliying]

Originally Posted by brian

Where have u assigned the text from textview. Is snapTitle and snapDesc textviews?

If so, then you have to use "snapTitle.text" instead of "snapTitle".

erm..snapDesc..so how do i go about doing it?

by writing

- (IBAction) save_Clicked:(id)sender {

	snap2playObj.snapDescription = self.viewDesc.text;
	//dismiss controller
	[self.navigationController dismissModalViewControllerAnimated:YES];
	
	[self.navigationController popViewControllerAnimated:YES];
}

i can "update" the text in textview but it aint storing anything into the database..because the method saveAllData wasnt being called at all..how do i call the method to update?argh

[yohliying]

anyone help?

[brian]

i can "update" the text in textview but it aint storing anything into the database..because the method saveAllData wasnt being called at all..how do i call the method to update?argh

YOu have to call the method, where it has to be called.

if the method is in same class, you can call it by

[self saveAllData];

[yohliying]

if the method is in another file?

[brian]

Originally Posted by yohliying

if the method is in another file?

You should call the function by creating an instance of the class which holds the function.