Delphi-Quellcode:
TAdoConnection(
DB).Attributes := [xaCommitRetaining, xaAbortRetaining];
[b]TAdoConnection(
DB).IsolationLevel := ilReadUncommitted;[/b]
TAdoConnection(
DB).LoginPrompt := False;
TAdoConnection(
DB).ConnectionTimeout := 30;
TAdoConnection(
DB).CommandTimeOut := 0;
TAdoConnection(
DB).Connected := True;
"Read Uncommitted" als Transaktionslevel ist eigenartig:
Zitat:
When this option is set, it is possible to read uncommitted or dirty data; values in the data can be changed and rows can appear or disappear in the data set before the end of the transaction.
http://
msdn.microsoft.com/en-us/library/aa259216(
SQL.80).aspx