iPhone-Sqlite: erreur liée à la contrainte

C'est mon code:

- (void) addOrder { if(addStmt == nil) { const char *sql = "insert into item(menuid,itemName,price,quantity,spiciness) Values( ?, ?, ?, ?,?)"; if(sqlite3_prepare_v2(database, sql, -1, &addStmt, NULL) != SQLITE_OK) NSAssert1(0, @"Error while creating add statement. '%s'", sqlite3_errmsg(database)); } // NSLog(@"ADDSTMT:%@",addStmt); sqlite3_bind_int(addStmt, 1, [menuID integerValue]); sqlite3_bind_text(addStmt, 2, [itemName UTF8Ssortingng], -1, SQLITE_TRANSIENT); sqlite3_bind_double(addStmt, 3, price ); sqlite3_bind_int(addStmt, 4, [quantity integerValue]); sqlite3_bind_text(addStmt, 5, [spiciness UTF8Ssortingng],-1,SQLITE_TRANSIENT); if(SQLITE_DONE != sqlite3_step(addStmt)) NSAssert1(0, @"Error while inserting data. '%s'", sqlite3_errmsg(database)); else menuID = [NSDecimalNumber numberWithLongLong:sqlite3_last_insert_rowid(database)]; //Reset the add statement. sqlite3_reset(addStmt); } 

Ici, datatables sont insérées dans la database mais l'erreur "Echec de la contrainte" a été générée.

salut mai b ce code vous aidera. insert des données avec ce style.

 sqlite3_stmt *stment; stment =nil; NSSsortingng *sql=[NSSsortingng ssortingngWithFormat:@"insert into DateSave(Date,Name) Values('%@','%@')",Date,strTestName]; if (sqlite3_open([databasePath UTF8Ssortingng], &database) == SQLITE_OK) { if (sqlite3_prepare_v2(database, [sql UTF8Ssortingng], -1, &stment, NULL) == SQLITE_OK) { sqlite3_step(stment); testID =sqlite3_last_insert_rowid(database); } } sqlite3_finalize(stment); sqlite3_close(database);