Writing to SQLite Database objective C Iphone SDK

Question

I need help writing new entries into an SQLite database using Objective C and the iPhone SDK.

The open/close/read database operations go okay, but I can't work out why this bit of code is not working.

-(void) testWriteToDatabase{

NSLog(@"instructions sent 3");
    sqlite3 *database;
    sqlite3_stmt *compiledStatement;
const char *insertSql="INSERT INTO data (name,pass,email) VALUES(?,?,?)";

NSString *userRegistered=userRegister.text;
NSLog(@"user %@",userRegistered);
NSString *passRegistered=passRegister.text;
NSLog(@"pass %@",passRegistered);
NSString *emailRegistered=emailRegister.text;
NSLog(@"email %@",emailRegistered);
sqlite3_stmt *insertStmt = nil;



if(sqlite3_open([databasePath UTF8String],&database) == SQLITE_OK) {

    if(sqlite3_prepare_v2(database, insertSql, -1, &insertStmt, NULL) == SQLITE_OK){

NSLog(@"instructions sent 4");
sqlite3_bind_text(insertStmt, 1, [userRegistered UTF8String], -1, SQLITE_TRANSIENT);
sqlite3_bind_text(insertStmt, 2, [passRegistered UTF8String], -1, SQLITE_TRANSIENT);
sqlite3_bind_text(insertStmt, 3, [emailRegistered UTF8String], -1, SQLITE_TRANSIENT);
            NSLog(@"instructions sent 5");
        while (sqlite3_step(compiledStatement) == SQLITE_ROW) {


        }

     }
sqlite3_reset(insertStmt);    
    }
sqlite3_close(database);    
}

To honest, I've never really used SQLite before, but the main problem is it's not adding entries to the database 'data' like i want it to. Help would be greatly appreciated, cheers.

Any reason you're talking directly to sqlite and not bothering with Core Data? — Thom
– Thom, Commented Jun 14, 2011 at 19:39
I would highly recommend using Gus Mueller's FMDatabase wrapper classes around SQLite. github.com/ccgus/fmdb — BP.
– BP., Commented Jun 14, 2011 at 19:40
I want to be able to download/upload the database to a server, so it's not restrictive. And to be honest, I never really considered it :/ — gunmania0
– gunmania0, Commented Jun 14, 2011 at 19:41
Only masochists use the SQLite C API directly in Objective-C. Use FMDB (a SQLite wrapper) or CoreData (an object graph manager) instead. — Dave DeLong
– Dave DeLong, Commented Jun 14, 2011 at 19:42
@Dave DeLong: real non-masochists use NSCoding, NSKeyedArchiver, NSKeyedUnarchiver, NSArray and NSSet. — user142019
– user142019, Commented Jun 14, 2011 at 21:09

Deepak Danduprolu · Accepted Answer · 2011-06-14 20:44:49Z

3

Shouldn't

while (sqlite3_step(compiledStatement) == SQLITE_ROW) {
}

be

while (sqlite3_step(insertStmt) == SQLITE_ROW) {
}

as you've used insertStmt everywhere else. compiledStatement is undefined as I understand your code.

answered Jun 14, 2011 at 20:44

Deepak Danduprolu

44.6k12 gold badges103 silver badges106 bronze badges

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

Comments

Seva Alekseyev · Accepted Answer · 2011-06-14 19:46:41Z

0

Does the database have a table called "data"? Trivial thing, but still. Also, do check what does the sqlite3_step return on every step.

answered Jun 14, 2011 at 19:46

Seva Alekseyev

61.8k25 gold badges174 silver badges297 bronze badges

3 Comments

gunmania0 Over a year ago

Yeah it does have a table called data, and okay i'll check for that.

gunmania0 Over a year ago

I'm struggling to find the code that calls what the Sqlite3_step function returns... - as i say i'm a complete novice with SQLite :/

gunmania0 Over a year ago

I ran this command: NSLog( @"Insert into row id = %d", sqlite3_last_insert_rowid(database)); The answer that it returned was 0.

Collectives™ on Stack Overflow

Writing to SQLite Database objective C Iphone SDK

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related