Does something it shouldnt.

Forum related to Firebird

Moderators: gto, cipto_kh, EgonHugeist

sfxcc
Senior Boarder
Senior Boarder
Posts: 95
Joined: 13.05.2010, 18:48

Does something it shouldnt.

Postby sfxcc » 08.06.2011, 21:47

I have a Db on fb running and my program.

If a open IBO change a value of a table post and commit it saves on db viewing by IBO or if i open a new program the new value is there.

But on the first program if a zquery (select aname * from nametable) it returns the old value and not the new one.

If i change the values on the same program it works returns the correct("new") value from the query.


This should not happen because im querying FB ,,

So Why it returns old values.?????
where's the code ..

sfxcc
Senior Boarder
Senior Boarder
Posts: 95
Joined: 13.05.2010, 18:48

Postby sfxcc » 10.06.2011, 23:33

I Found the Solution is Isolation Level must be READ COMMITED...

How Can i change From SNAPSHOT To READ COMMITED ???????
where's the code ..

User avatar
mdaems
Zeos Project Manager
Zeos Project Manager
Posts: 2766
Joined: 20.09.2005, 15:28
Location: Brussels, Belgium
Contact:

Postby mdaems » 30.08.2011, 20:13

ZConnection1.TransactIsolationLevel := <x> where <X> is one of (tiNone, tiReadUncommitted, tiReadCommitted, tiRepeatableRead, tiSerializable)
Default should be tiSerializable.

Mark
Image


Return to “Firebird”

Who is online

Users browsing this forum: No registered users and 1 guest