Databases
StackOverflow2013
Postsdbo
POSQLite3 database doesn't actually insert data - iPhone
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POSQLite3 database doesn't actually insert data - iPhone
    primarykey
    data
    text
    <p>I'm trying to add a new entry into my database, but it's not working. There are no errors thrown, and the code that is supposed to be executed after the insertion runs, meaning there are no errors with the query. But still, nothing is added to the database. I've tried both prepared statements and the simpler sqlite3_exec and it's the same result.</p> <p>I know my database is being loaded because the info for the tableview (and subsequent tableviews) are loaded from the database. The connection isn't the problem.</p> <p>Also, the log of the sqlite3_last_insert_rowid(db) returns the correct number for the next row. But still, the information is not saved.</p> <p>Here's my code:</p> <pre><code>db = [Database openDatabase]; NSString *query = [NSString stringWithFormat:@"INSERT INTO lists (name) VALUES('%@')", newField.text]; NSLog(@"Query: %@",query); sqlite3_stmt *statement; if (sqlite3_prepare_v2(db, [query UTF8String], -1, &amp;statement, nil) == SQLITE_OK) { if (sqlite3_step(statement) == SQLITE_DONE){ NSLog(@"You created a new list!"); int newListId = sqlite3_last_insert_rowid(db); MyList *newList = [[MyList alloc] initWithName:newField.text idNumber:[NSNumber numberWithInt:newListId]]; [self.listArray addObject:newList]; [newList release]; [self.tableView reloadData]; sqlite3_finalize(statement); } else { NSAssert1(0, @"Error while inserting data. '%s'", sqlite3_errmsg(db)); } } [Database closeDatabase:db]; </code></pre> <p>Again, no errors have been thrown. The prepare and step statements return SQLITE_OK and SQLITE_DONE respectively, yet nothing happens.</p> <p>Any help is appreciated!</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USkiamlaluno
    1. USMishieMoo
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    3. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POSQLite3 database doesn't actually insert data - iPhone
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POSQLite3 database doesn't actually insert data - iPhone
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POSQLite3 database doesn't actually insert data - iPhone
      1. This table or related slice is empty.
      1. VTUpMod
    1. COHave a look to Core Data someday
      singulars
      1. POSQLite3 database doesn't actually insert data - iPhone
      1. USIlDan
    2. COCore data doesn't quite fit what I'm trying to do. I prefer working with SQL, thanks.
      singulars
      1. POSQLite3 database doesn't actually insert data - iPhone
      1. USMishieMoo
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload