Hello,

I searched a lot ... maybe it is just not possible.
I 'd like to be able to do a select on a table on which another traitement is doing an update.
I do no want to be 'stopped' by the lock on the row that are beeing updated.
I do not want to select the lines that are beeing updated (It's OK to miss the rows, but it's not OK to have rows with "wrong" values).

Example
TableTest :
ID Value
1 test1
2 test2
3 test3
4 test4

begin tran
Update TableTest set Value = test0 where ID = 3

Select * from TableTest

I need the result (imediatly) from select to be :
ID Value
1 test1
2 test2
4 test4


Thank you !!
(Sybase 12.5.1)