Inserting into SQLite

[sarahhbabyyyy]

Hi Everyone,
I have been stuck on this for the past two days! So basically, I am trying to get what the user typed into the app and store it into the SQLite database. I can already read data from it but for some reason, my insert is not working! Can someone please help? Thanks!

Here's my insert code:

-(void) insertSavedData
{
databaseName = @"Database.sqlite";
NSArray *documentPaths = NSSearchPathForDirectoriesInDomains(NSDocumentDire ctory, NSUserDomainMask, YES);
NSString *documentsDir = [documentPaths objectAtIndex:0];
dbPath = [documentsDir stringByAppendingPathComponent:databaseName];

int addID;

// Open the database from the users filessytem
if(sqlite3_open([dbPath UTF8String], &database) == SQLITE_OK) {
NSLog(@"in method");
if(addStmt == nil) {
const char *sql = "insert into vehicleInfo(vehicleID, brandName, modelName, vehicleType, idr, spur, pinion) values(?,?,?,?,?,?,?)";
if(sqlite3_prepare_v2(database, sql, -1, &addStmt, NULL) != SQLITE_OK)
{
NSAssert1(0, @"Error while creating add statement. '%s'", sqlite3_errmsg(database));
}
}

sqlite3_bind_double(addStmt, 1, 500);
sqlite3_bind_text(addStmt, 2, [@"test" UTF8String], -1, SQLITE_TRANSIENT);
sqlite3_bind_text(addStmt, 3, [@"test" UTF8String], -1, SQLITE_TRANSIENT);
sqlite3_bind_text(addStmt, 4, [@"test" UTF8String], -1, SQLITE_TRANSIENT);
sqlite3_bind_double(addStmt, 5, 1);
sqlite3_bind_double(addStmt, 6, 1);
sqlite3_bind_double(addStmt, 7, 1);

if(SQLITE_DONE != sqlite3_step(addStmt))
NSAssert1(0, @"Error while inserting data. '%s'", sqlite3_errmsg(database));

else
{
//SQLite provides a method to get the last primary key inserted by using sqlite3_last_insert_rowid
addID = sqlite3_last_insert_rowid(database);
NSLog(@"in method %d", addID);
}

//Reset the add statement.
sqlite3_reset(addStmt);
}
sqlite3_finalize(addStmt);

sqlite3_close(database);
}


Thank you in advance!