Firebird SQLDB TRANSACTION
lazarus / 16-Databases

----------------------------------------------------------------------
k1attila1 · 2013-06-03 10:26

Could somebody tell me what the correct params for SQLTransaction are
if i don't want

"lost updates".

maybe this :

isc_tpb_version3
isc_tpb_read_committed
isc_tpb_no_rec_version
isc_tpb_nowait

but this isn't work well

----------------------------------------------------------------------
BigChimp · 2013-06-03 10:27

Defaults work well, as long as you properly commit your transactions
(or use CommitRetaining)

See http://wiki.lazarus.freepascal.org/Firebird_in_action#Advanced_tra
nsactions

----------------------------------------------------------------------
k1attila1 · 2013-06-03 11:14

Ok, thanks BigChimps, but then the dbnavigator refresh button
doesn't refresh the query.

Why ?

It refresh it if i use readcommitted isolation level.

----------------------------------------------------------------------
BigChimp · 2013-06-03 11:20

No idea, not a GUI guy.

----------------------------------------------------------------------
ludob · 2013-06-04 07:04

Quote from: k1attila1 on June 03, 2013, 01:14:49 pm
Ok, thanks BigChimps, but then the dbnavigator refresh button
doesn't refresh the query.

Why ?

It refresh it if i use readcommitted isolation level.
Can you be a little more precise? When is the dbnavigator not
refreshing the query? What changes are you expecting to see? Own
changes, changes from another transaction, committed or not commited?

The refresh button is just reissuing the same query. What it returns
depends all on your transaction isolation level and when you started
the transaction. If you do a CommitRetaining when applying updates a
new transaction is started immediately. When no transaction is
pending, a new transaction will be started when you click on refresh
and this transaction will stay open until you close it. So if you use
the concurrency isolation level you can refresh as many times as you
want, it'll return always the same data. But without any more
information this is just guessing.

----------------------------------------------------------------------
k1attila1 · 2013-06-06 05:12

Many thanks for everybody

But i find the solution instead of standard refresh button:

I make a button with  an OnClick event :

SQLTransaction1.Commit;
SQLQuery1.Open; 

(It was only problem with RepeatableRead (concurency9 isolation
level.)

Refresh works well