thanks alot Gianluca Sartori ...

and about the code, its very long and related so much to our system.

but im saying that its not related to code ...

its related to number...

Select ,Modify and also some of arithmatic operation ...

but every user has his own data, so lock on table will be only for his data and will not affect other...