Update query in sqlite3 problem
        Posted  
        
            by user271753
        on Stack Overflow
        
        See other posts from Stack Overflow
        
            or by user271753
        
        
        
        Published on 2010-04-26T05:38:13Z
        Indexed on 
            2010/04/26
            5:43 UTC
        
        
        Read the original article
        Hit count: 286
        
[sqlite executeQuery:@"UPDATE UserAccess SET Answer ='Positano';"]; NSArray *query2 = [sqlite executeQuery:@"SELECT Answer FROM UserAccess;"]; NSDictionary *dict = [query2 objectAtIndex:0]; NSString *itemValue = [dict objectForKey:@"Answer"]; NSLog(@"%@",itemValue);
It does print Positano at this point .. But when I just print without the update query again . I get the old entry which is Paris.
What am I doing wrong ??? I am using http://th30z.netsons.org/2008/11/objective-c-sqlite-wrapper/ wrapper.
Regards , Novice
© Stack Overflow or respective owner