Inserting Rows in Database Using Sqlite Iphone

Question

I have the following code n i have 4 records in data base but loop is running 2 times n getting only first row two times whats a problem in my code?

- (void) getAllRowsFromTableName:(NSString *)tableName{
    NSString *qsql = [NSString stringWithFormat:@"SELECT * FROM '%@'",tableName];
   
    NSLog(@"query is :%@",qsql);
    sqlite3_stmt *statement;
    if (sqlite3_prepare_v2(db,[qsql UTF8String] , -1, &statement,nil) == SQLITE_OK) {
        while (sqlite3_step(statement) == SQLITE_ROW) {
            NSLog(@"loop");
            int catId = sqlite3_column_int(statement, 1);
             NSLog(@"***CatId is :%d",catId);

                sqlite3_finalize(statement);
        }
        sqlite3_finalize(statement);
    }

Try with commenting the sqlite3_finalize(statement); inside the while loop. — Ravin
– Ravin, Commented Mar 1, 2012 at 14:22
yes u r right by commenting the sqlite3_finalize(statement); inside the while loop my code is now working fine Thanks Ravin. — user1242803
– user1242803, Commented Mar 1, 2012 at 14:30

elp · Accepted Answer · 2012-03-01 14:09:02Z

2

Wow! Another that use sqllite3 natively!! :)

I would suggest you an external lib (2 files) named FMDB, that is a wrapper to sqllite3.

https://github.com/ccgus/fmdb

Easy to use. Hope this helps.

answered Mar 1, 2012 at 14:09

elp

8,1037 gold badges65 silver badges124 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ravin · Accepted Answer · 2012-03-01 15:50:47Z

0

Just to complete and close this question I am putting my comment in answer.

Try with commenting the sqlite3_finalize(statement); inside the while loop. Explaination:

SQLite.org says

The sqlite3_finalize() function is called to delete a prepared statement.

Also,

The application must finalize every prepared statement in order to avoid resource leaks. It is a grievous error for the application to try to use a prepared statement after it has been finalized. Any use of a prepared statement after it has been finalized can result in undefined and undesirable behavior such as segfaults and heap corruption.

Thanks,

edited Mar 1, 2012 at 15:50

answered Mar 1, 2012 at 14:44

Ravin

8,5443 gold badges22 silver badges19 bronze badges

Collectives™ on Stack Overflow

Inserting Rows in Database Using Sqlite Iphone

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related