Re: How to change Transaction Isolation Level

What Database?
Anyway ADOConnection has an IsolationLevel property.
ADOConnection1.IsolationLevel := ilReadUncommitted;

Should work but in some environments (COM+ for example) IsolationLevel can't be changed that easily.
In that case and if your DB is SQL SERVER you could try tablehints to allow dirty reads.

Example:
Select t1.c2 from t1 WITH (NOLOCK)

Ralf



.