Hi i am executing a particular code in which i am deleting a record form a table.
If i execute it in the debug mode and put a break point on the delete statement ,it gets hit and when i step from it it deletes the record from the table.
However if i execute it in complie mode the record doesnt get deleted from the table.

Any ideas as to why this may be happening?

Post the code and maybe someone will see what is happening.