¡@
2014/10/15 ¤U¤È 10:09:33
iphone Programming Glossary: getdatabasepathHow to insert a record in Sqlite? http://stackoverflow.com/questions/4310852/how-to-insert-a-record-in-sqlite c iphone objective c sqlite ios4 share improve this question You can use a block of code like this NSString GetDatabasePath NSArray paths NSSearchPathForDirectoriesInDomains NSDocumentDirectory NSUserDomainMask YES NSString documentsDirectory paths.. stringByAppendingPathComponent @ Your Database void InsertPurchase sqlite3_stmt statement nil NSString path self GetDatabasePath NSString query if sqlite3_open path UTF8String db SQLITE_OK query NSString stringWithFormat @ Your insert querry if sqlite3_prepare_v2..
making map coordinates(lan,& long)storing in sqlite database http://stackoverflow.com/questions/5630491/making-map-coordinateslan-longstoring-in-sqlite-database DataBase NSObject sqlite3 database DataBase shareDataBase BOOL createDataBase NSString DataBaseName NSString GetDatabasePath NSString database NSMutableArray getAllDataForQuery NSString sql forDatabase NSString database void inseryQuery NSString.. nil DataBase shareDataBase if SampleDataBase SampleDataBase DataBase alloc init return SampleDataBase NSString GetDatabasePath NSString database1 self createDataBase database1 NSArray paths NSSearchPathForDirectoriesInDomains NSDocumentDirectory NSUserDomainMask.. getAllDataForQuery NSString sql forDatabase NSString database1 sqlite3_stmt statement nil NSString path self GetDatabasePath database1 NSMutableArray alldata alldata NSMutableArray alloc init if sqlite3_open path UTF8String database SQLITE_OK NSString..
|