I know this is basic and should be in the documentation, but it is not quite clear to me. Basically I have 3 type of procedures:
1. Getting values from a table. For this I have the following steps: (Open) Prepare Then in a loop: Step ColumnInt, ColumnDouble, ColumnText After the loop: Finalize 2. Putting values in a table: (Open) Start Transaction Prepare Then in a loop: Bind Step Reset After the loop: Clearbindings Finalize Commit Transaction 3. Non looped procedures, eg, delete and update: (Open) Prepare Step Reset Finalize Is this all how it should be? Where/when should I call sqlite3_close? Does Clearbindings come indeed before finalize? Thanks for any clarification. RBS