¡@
2014/10/15 ¤U¤È 10:13:15
iphone Programming Glossary: remindersdbPopulate the table view sections with rows of table in sqlite database in an order http://stackoverflow.com/questions/8475446/populate-the-table-view-sections-with-rows-of-table-in-sqlite-database-in-an-ord UITableView view NSInteger numTableRecords 1 sqlite3_stmt statement if sqlite3_open self.databasePath UTF8String remindersDB SQLITE_OK NSString sqlStatement NSString stringWithFormat @ select count from reminders const char sql sqlStatement cStringUsingEncoding.. count from reminders const char sql sqlStatement cStringUsingEncoding NSUTF8StringEncoding if sqlite3_prepare_v2 remindersDB sql 1 statement NULL SQLITE_OK while sqlite3_step statement SQLITE_ROW numTableRecords sqlite3_column_int statement.. numTableRecords sqlite3_column_int statement 0 else printf could not prepare statement s n sqlite3_errmsg remindersDB else NSLog @ Error in Opening Database File sqlite3_close remindersDB return numTableRecords Now my problem here is I..
http://stackoverflow.com/questions/8574342/retrieve-all-rows-inserted-in-sqlite-database-and-display-in-table-view-cells-co UITableView view numTableRecords 1 sqlite3_stmt statement if sqlite3_open self.databasePath UTF8String remindersDB SQLITE_OK NSString sqlStatement NSString stringWithFormat @ select count from reminders const char sql sqlStatement cStringUsingEncoding.. count from reminders const char sql sqlStatement cStringUsingEncoding NSUTF8StringEncoding if sqlite3_prepare_v2 remindersDB sql 1 statement NULL SQLITE_OK while sqlite3_step statement SQLITE_ROW numTableRecords sqlite3_column_int statement.. numTableRecords sqlite3_column_int statement 0 else printf could not prepare statement s n sqlite3_errmsg remindersDB else NSLog @ Error in Opening Database File sqlite3_close remindersDB NSLog @ Number of records d numTableRecords return..
Incorrect number of objects getting added to mutable array http://stackoverflow.com/questions/9091647/incorrect-number-of-objects-getting-added-to-mutable-array objectAtIndex 7 sqlite3_stmt statement nil const char dbpath databasePath UTF8String if sqlite3_open dbpath remindersDB SQLITE_OK textField.text nil if self.navigationItem.rightBarButtonItem.title @ Save NSLog @ am in the save loop NSString.. isSelected fieldFive.text textView.text fieldSix.text const char insert_stmt insertSQL UTF8String sqlite3_prepare_v2 remindersDB insert_stmt 1 statement NULL if sqlite3_step statement SQLITE_DONE UIAlertView alert UIAlertView alloc initWithTitle @.. @ Ok otherButtonTitles nil alert show alert release Check the last inserted row id rowID sqlite3_last_insert_rowid remindersDB NSLog @ last inserted rowId d rowID sqlite3_finalize statement sqlite3_close remindersDB self.tableView reloadData Now the..
|
