Hi all.

My colleague has a problem.

Anyone help the following ?

Here is my colleague' e-mail.
<<QUATE>>
Hi,
A question about set the isolation to informix cursor stability.
Usually we can set the isolation level like this,
cn.IsolationLevel = adXactReadUncommitted ' or adXactReadCommitted;
adXactCursorStability; adXactRepeatableRead
cn.BeginTrans
....

The problem is, in ADO adXactCursorStability is an equivalent of
adXactReadCommitted.
Therefore setting the isolation level to adXactCursorStability doesnot
really change it to
Informix cursor stability. It's still read committed.

Could you pls point out is there any way to set the isolation level to
Informix cursor stability?

Some backgrounds:
I have some concurrency problem using read committed as isolation
level.
They need to lock the row to read. Repeatable read is too aggresive.
Cursor stability will be ideal.

Thanks
<</QUATE>>

TIA.

--
Tsutomu Ogiwara from Japan