Subject | Re: [firebird-support] Read uncommitted |
---|---|
Author | eMeL |
Post date | 2010-08-17T01:27:32Z |
> Is there any way of reading uncommitted data of another transactions?No way but read about "No record version" (See in IB6 original document
pack).
This is a part of my transaction component (C++Builder/IBX):
Params->Clear();
switch (FTransIsolation)
{
case tiSnapshot :
Params->Add("concurrency");
break;
case tiReadCommitted :
Params->Add("read_committed");
Params->Add("rec_version");
break;
case tiReadCommitted_NoVer :
Params->Add("read_committed");
Params->Add("no_rec_version");
break;
case tiTableStability :
Params->Add("consistency");
break;
}
if (FTransWait)
{
Params->Add("wait");
}
else
{
Params->Add("nowait");
}
if (TransReadOnly)
{
Params->Add("read");
}
else
{
Params->Add("write");
}
eMeL