Geek asks and answers

EXC_BAD_ACCESS in sqlite_step (statement)

I am using sqlite database for iphone application. but its crash on the line while loop when collecting data from the database sometimes.

-(void)GetMethod
{

    NSString *query = [[NSString alloc] initWithFormat:@"SELECT * FROM errorlogs"];
    sqlite3_stmt *statement;    
    if (sqlite3_prepare_v2(database, [query UTF8String],-1, &statement, nil) == SQLITE_OK) 
    {
        while (sqlite3_step(statement) == SQLITE_ROW) **// EXC_BAD_ACCESS ON THIS LINE**
        { 
            char *uid1 = (char *)sqlite3_column_text(statement, 0);
            NSString *uid = [NSString stringWithFormat:@"%s",uid1];
        }
    }
    sqlite3_finalize(statement);
}

why am I getting this EXC_BAD_ACCESS during the loop.

enter image description here Thank.

+5
source share
2 answers

Either sqlite3_step(statement)either SQLITE_ROWnot initialized or already released. When it performs an equality check on a non-existent object, it issues an EXE_BAD_ACCESS.

Do you return any rows?

+2
source

Try using the FMDB frame, it helped me a lot in my project.
Here's the link: https://github.com/ccgus/fmdb
Let him see if you can;)

+3

More articles:


All Articles