Subject Re: [firebird-php] Ibase_query -> specify transaction
Author Dmitry Kalugin
Добрый день, Simon!

Monday, June 13, 2005, 9:45:44 PM, вы писали:

SC> Start connection.
SC> Start read only tran
SC> Read a bunch of records
SC> Start r/w tran
SC> Update record
SC> Commit r/w tran
SC> Start r/w tran
SC> Update record
SC> Commit r/w tran
Commit read only tran (!!!) //SC>Rollback read only tran
SC> Close connection


Transactions must be completed on Commit, even if they
only for reading.
Read about that as assembling of garbage of versions works.
Rollbak follows to apply ONLY for the recoil of changes.

--
Best regards,
Dmitry Kalugin
Delphi/FireBird programmer
Ukraine, Donetsk
ICQ177363