Function with argument to a NSInvocation method

Answer 1

The problem you could be having is that your prepared statement is invalid after sqlite3_close. You need to create a new prepared statement each time you open the database.

1. Open the database with sqlite3_open.
2. Prepare the statement with sqlite3_prepare and friends.
3. Bind with sqlite3_bind.
4. Step with sqlite3_step.
5. Afterwards, ensure you call sqlite3_finalize.
6. Close the database with sqlite3_close.

You can't just reset the statement, because that statement was prepared for a different database handle.

NB

I'm not too familiar with SQLite.