ADO + Mehrbenutzerbetrieb + Transaktionen + SQL Server

[mjustin]

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