1) Is 'COMMIT' or 'ROLLBACK' missing in application after DELETE statement..

Otherwise there should not be any problem even though two users are deleting same set of rows...

If first user issues a delete statement

f.ex

DELETE FROM test WHERE id =1;

and if he doesn't COMMIT/ROLLBACK after deleting rows..

second user will hang if he tries to delete same set of rows.. here is exm..

DELETE FROM test WHERE id =1;

2) Or Is there any messgage dialog box which gets confirmation of DELETE operation??.. and then COMMITS/ROLLBACK based on user response..

In this case.. there is a possibility of missing COMMIT/ROLLACBK statements.... Sometimes application programmers do miss these things which creates such problems..


HTH

Sameer

[Edited by Sameer on 09-17-2002 at 06:45 AM]