Update query in sqlite3 problem
- by user271753
[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