How set READ COMMITTED in TIB connection
lazarus / 16-Databases

----------------------------------------------------------------------
Fortuna1 · 2012-05-19 07:51

How execute this.
IBConnection1.ExecuteDirect('SET TRANSACTION WAIT ISOLATION LEVEL READ
COMMITTED');

----------------------------------------------------------------------
exdatis · 2012-05-19 07:57

transactionIB.Action:= caCommitRetaining;//or caCommit;
caRollbackRetaining, caRollback ...
Regards.

----------------------------------------------------------------------
Fortuna1 · 2012-05-19 08:43

this isn't solution of problem.




http://www.firebirdsql.org/refdocs/langrefupd20-set-trans.html
http://tech.groups.yahoo.com/group/firebird-support/message/58653


http://wiki.freepascal.org/Firebird_in_action#Transaction_isolation_le
vels

Problem stays
How to set Read commited

----------------------------------------------------------------------
ludob · 2012-05-19 11:23

Add 'isc_tpb_read_committed' to SQLTransaction.Params in the Object
Inspector or

Code: [Select]IBConnection1.Transaction.Params.Text:='isc_tpb_read_com
mitted'
Edit: I overlooked the WAIT in your SQL statement. Add also
'isc_tpb_wait' to the params or

Code: [Select]IBConnection1.Transaction.Params.Text:='isc_tpb_read_com
mitted;isc_tpb_wait';

----------------------------------------------------------------------
Fortuna1 · 2012-05-19 12:23

Thanks.

----------------------------------------------------------------------
BigChimp · 2012-05-19 12:24

Any additions to
http://wiki.lazarus.freepascal.org/Firebird_in_action#Advanced_transac
tions
welcome

----------------------------------------------------------------------
ludob · 2012-05-19 13:45

Quote from: BigChimp on May 19, 2012, 02:24:41 pmAny additions to
http://wiki.lazarus.freepascal.org/Firebird_in_action#Advanced_transac
tions
welcome
Perfect. Now getting people to read it