Hi, I have a couple questions about using prepared statements with sqlite.
If I prepare a statement can I bind variables as my value and then set the variables in a loop and execute? Or in my loop would I bind my values and step so each bind gets executed until it equals SQLITE_DONE then reset? I guess I am just unclear on how to execute my prepared statement and set my values in a loop. Is there a better way to do what I want? Am I completely off base? Any info is much appreciated. This is my first time working with the sqlite3 api and sqlite so please forgive any ignorance. Thanks a lot, - Jon
