SQLite insert data in objective c

Question

I want to insert some data to mydatabase.sqlite but I have a problem. There is no error message when inserting data but then I open database and I cant see any data. There isnt any data.

this is addCoffee method in MyClass:

if(addStmt == nil) {
    const char *sql = "insert into records(Date, Latitude, Longitude) 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_text(addStmt, 1, [Date UTF8String], -1, SQLITE_TRANSIENT);
sqlite3_bind_double(addStmt, 2, [Latitude doubleValue] );
sqlite3_bind_double(addStmt, 3, [Longitude doubleValue] );

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
    recordID = sqlite3_last_insert_rowid(database);

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

sending data:

iDailyAppDelegate *appDelegate = (iDailyAppDelegate *)[[UIApplication sharedApplication] delegate];

//Create a MyClass Object.
MyClass *coffeeObj = [[MyClass alloc] initWithPrimaryKey:0];
coffeeObj.Date = dateInString;
NSDecimalNumber *temp = [[NSDecimalNumber alloc] initWithString:first];
coffeeObj.Latitude = temp;
NSDecimalNumber *temp2 = [[NSDecimalNumber alloc] initWithString:second];
coffeeObj.Longitude = temp2;
[temp release];
coffeeObj.isDirty = NO;
coffeeObj.isDetailViewHydrated = YES;

//Add the object
[appDelegate addCoffee:coffeeObj];

Is it possible that you executed 'BEGIN TRANSACTION' somewhere and didn't execute a corresponding 'COMMIT'? — rob mayoff, Oct 24 '11 at 06:23

Tendulkar · Accepted Answer · 2011-10-24T09:40:54.993

1

- (void)inserting{

    database=nil;
    if (sqlite3_open([[DBAction getSqlitePath] UTF8String], &database) == SQLITE_OK){
        const char *sql = [[NSString stringWithFormat:@"insert  into SiteTable set Site_Address = '%@'",someString] UTF8String];
        sqlite3_stmt *updateStmt = nil;
        if(sqlite3_prepare_v2(database, sql, -1, &updateStmt, NULL) != SQLITE_OK)
        {
            //NSAssert1(0, @"Error while creating update statement. '%s'", sqlite3_errmsg(database));
        }
        if (SQLITE_DONE != sqlite3_step(updateStmt)){
            //NSAssert1(0, @"Error while creating database. '%s'", sqlite3_errmsg(database));
        }
        sqlite3_reset(updateStmt);
        sqlite3_finalize(updateStmt);
    }
    else{
        //NSAssert1(0, @"Error while opening database '%s'", sqlite3_errmsg(database));
    }
    sqlite3_close(database);

}

edited Oct 24 '11 at 09:40

answered Oct 24 '11 at 07:36

Tendulkar

5,550
2
27
53

why you are using update statement instead of insert? Also, I tried this way but it is not record, too :S – Hacer sengul Akac Oct 24 '11 at 08:03
Ok, I modified my code. Also, I running my application on device. Because of location update. How can I find my database file? for simulator the way is ~/Library/Application Support/iPhone Simulator/{verison}/Applications/{app id}. But How can I see my database file when running on device? I cant see at this path? – Hacer sengul Akac Oct 24 '11 at 10:25
I found it at organizer, thnx for all – Hacer sengul Akac Oct 24 '11 at 11:07

score 1 · Answer 2 · answered Oct 24 '11 at 07:41

1

Create NSLog for all sql commands that you send to database and then try to execute them from the terminal and you will see all errors and be able to fix them

answered Oct 24 '11 at 07:41

Amar Kulo

1,098
8
18

there are nslog after every sql statement..it is not give me any error message!! – Hacer sengul Akac Oct 24 '11 at 08:04

SQLite insert data in objective c

2 Answers2