SQLite3 - Library routine called out of sequence
Uopon further investigation I found my mistake. I should have first opened the db before running the prep statement.
The code should look like this:
sqlite3 *lDb;sqlite3_stmt *lStmt;NSNumberFormatter *lNbrFmt = [[[NSNumberFormatter alloc] init] autorelease];// Define SQL statement NSString *lSql = @"SELECT section, language, title, description"@" selector-x-pos, selector-y-pos, gps-x-pos, gps-y-pos"@" FROM sections"@" ORDER BY section ASC";if(sqlite3_open([[fileMethods databasePath] UTF8String], &lDb) == SQLITE_OK) { lSqlResult = sqlite3_prepare_v2(lDb, [lSql UTF8String], -1, &lStmt, NULL); NSLog(@"%@", [NSString stringWithUTF8String:sqlite3_errmsg(lDb)]);...