[SOLVED] MySQL Isolation Levels

[Pascal]

How do i set the MySQL isolation level to "READ COMMITTED"?

I tried

Code: Pascal  [Select][+][-]

1. ExecuteDirect('SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;');

with no luck.

What is the correct way to do this?

Pascal

[Pascal]

I know, that i can use

Code: Pascal  [Select][+][-]

1. Transaction.Active := False;

But i would like to not use this.

[Pascal]

Code: Pascal  [Select][+][-]

1. ExecuteDirect('SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;');
2. Transaction.Commit;

Commit was missing!