When selecting you start on 0, using statements that look like this:
self.commentId = sqlite3_column_int(selectstmt, 0); self.email = [NSString stringWithUTF8String:(char *)sqlite3_column_text(selectStmt, 1)];
But when inserting you start on 1 using similar statements:
sqlite3_bind_text(insertStmt, 1, [self.contactName UTF8String], -1, SQLITE_TRANSIENT);
Another quirk:
It's SQLite, not SQLLite!
It's a bit quirky, but once you get to know how to use SQLite with iOS it becomes really helpful!
P.S.: Here is a tutorial that I found helpful:
http://www.iphonesdkarticles.com/2008/10/sqlite-tutorial-selecting-data.html
No comments:
Post a Comment