Hello Gustavo.

The solution is not on the database but in your application. It has to do
the sell in two steps and you have two ways to do this.

1 - the application allocates immediatelly the part of the stok to the first
seller (70) and when the second looks there will be only 30 to sell.

2 - the application permit each seller to use all the stok (70 + 50), and at
the end it confirms the qualtity the real can sell.

For both solutions, your application must has a way to rollback or commit
the sell when it crashes and return back up. The important is that the
solution is not on the database but in the application.

[]'s,

--
Marco Antonio Abreu
mabreu.ti@...
System Analist/Developer/DBA


2010/8/16 eMeL <emel@...>

>
>
>
> > Is there any way of reading uncommitted data of another transactions?
>
> Sorry, my answer before not for this problem.
>
> eMeL
>
>

[Non-text portions of this message have been removed]