I did several tests configuring transaction isolation, but I may be doing something wrong as it is not querying with the isolation I request.
Can you give me a correct example of how to use it?
Sample:
Code: Select all
IBCConnection1.DefaultTransaction.IsolationLevel := iblReadOnlyReadCommitted;
IBCConnection1.Open;
IBCConnection1.StartTransaction;
IBCQuery1.Close;
IBCQuery1.SQL.Text := 'select * from test';
IBCQuery1.Open;
IBCConnection1.Commit;
Thanks.
Best Regarts;