RE: [Firebird-net-provider] Reply to two people, Alan McDonald and Carlos Guzman Alvarez, with questions about transactions

[Alan M. <al...@me...>]

> Thanks for jumping in here!
>

Jason,
What you are probably unaware of is that all transaction based SQL databases
require transactions to do all things... read , update and delete. What you
are being insulated from with MSSQL and with many ODBC drivers is that when
you issue the select statement, it starts a transaction (an implicit one)
for you and commits it after giving you the answer (result set). All half
decent drivers will also give you the opportunity to include more than one
statement in this transaction by way of opening (starting manually) your own
explicit transaction, issuing serverl astatements and then explicitly
closing the transaction. If you explicitly open a transaction you must
explicitly close it (commit or rollback). If you leave it to the implicit
transaction, then each and every statement that you issue will be carried
out under it's very own little transaction.
Hope this helps
Alan