title: How to commit a SQLite transaction in C/C++?
body: <p>I am using sqlite c/c++ interface.</p>
  
  <p>I have 3 tables (related tables) say A, B, C. Now, there is a function called <strong>Set</strong>, which get some inputs and based on the inputs inserts rows into these three tables. (sometimes it can be an update in one of the tables)</p>
  
  <p>Now I need two things. One, i dont want autocommit feature. Basically I would like to commit after every 1000 calls to <strong>Set</strong> function</p>
  
  <p>Secondly, within the set function itself, if i find that after inserting into two tables, the third insert fails, then i have to revert, those particular changes in that <strong>Set</strong> function call.</p>
  
  <p>Now i don't see any sqlite3_commit function exposed. I only see a function called sqlite3_commit_hook() which is slightly diff in documentation.</p>
  
  <p>Are there any function exposed for this purpose? or What is the way to achieve this behaviour?</p>
  
  <p>Can you help me with the best approach of doing this.</p>