Try FMDB
Download the lib package and take a look in the example file included.
FelipeOliveira
2010-10-24 01:49:03
A:
+2
A:
FMDB is here: http://github.com/ccgus/fmdb/tree/master/src/
The sample you are looking for is also on that page; the sample is "fmdb.m".
Graham Perks
2010-10-24 02:21:24
+1 for the link
Dave DeLong
2010-10-24 02:29:14
In the example, no have a example about query to delete. Just have to insert, update and create a new table.
2010-10-24 19:02:37
Pass your DELETE to executeUpdate, like the example's INSERT and CREATEs.
Graham Perks
2010-10-24 20:32:18
I tryed this and not worked: NSAutoreleasePool * pool = [[NSAutoreleasePool alloc] init]; FMDatabase* db = [FMDatabase databaseWithPath:@"/quickdatabase.db"]; [db open] [db setShouldCacheStatements:YES]; [db executeUpdate:@"delete from Enquetes where Nome = ?", [arrayAsk objectAtIndex:indexPath.row]]; [db close]; [pool release]; return 0;
2010-10-25 00:28:46
=[db setShouldCacheStatements:YES]= is experimental, so try without that. At this point I would triple-check the arrayAsk content; try the SQL with a hard-coded value. What exactly is failing? Check for errors Do you have write access to that file? Try adding =FMDBQuickCheck([db hadError]);= to check for errors.
Graham Perks
2010-10-25 02:14:35