Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- sqlite3_stmt *statement = nil;
- @try {
- sqlite3_open([databasePath UTF8String], &database);
- @try {
- NSString *queryStatement = @"INSERT INTO People (ID_Organization, Name, EMail) VALUES (?, ?, ?);";
- sqlite3_prepare_v2(database, [queryStatement UTF8String], -1, &statement, NULL);
- @try {
- sqlite3_bind_int(statement, aPerson.organizationID, 1);
- sqlite3_bind_text(statement, 2, [aPerson.name UTF8String], -1, NULL);
- sqlite3_bind_text(statement, 3, [aPerson.eMail UTF8String], -1, NULL);
- sqlite3_step(statement);
- NSLog(@"Person inserted.");
- aPerson.ID = sqlite3_last_insert_rowid(database);
- return TRUE;
- }
- @catch (NSException *exception) {
- NSLog(@"%s", sqlite3_errmsg(database));
- return FALSE;
- }
- }
- @catch (NSException *exception) {
- NSLog(@"%s", sqlite3_errmsg(database));
- return FALSE;
- }
- @finally {
- sqlite3_reset(statement);
- }
- }
- @catch (NSException *exception) {
- NSLog(@"%s", sqlite3_errmsg(database));
- return FALSE;
- }
- @finally {
- sqlite3_close(database);
- }
Advertisement
Add Comment
Please, Sign In to add comment