title: How do I use transactions in Firebird?
body: <p>In MS SQL Server, I can easily put multiple insert statements into a transaction, like so:</p>
  
  <pre><code>begin tran
  insert into mytable values (1, 2, 3)
  insert into mytable values (4, 5, 6)
  commit tran
  </code></pre>
  
  <p>I'm trying to do the same thing in Firebird, but I can't figure out the syntax.  Googling for "Firebird transaction syntax" returns nothing useful.  I've found enough to know that transaction support <em>exists</em>, but no examples for how to use it right.</p>
  
  <p>So I figure I may as well ask on here.  Does anyone know how to write a transaction using multiple inserts for a Firebird database?</p>