Delete query

• Adhish Kumar Kundu

  Newbie

  Points: 1

  More actions

  July 27, 2005 at 11:36 pm

  #89314

  I have a problem with delete query. Whenever I am deleting a record from my database table a new rercord automatically added. Can some body help me in this regards.The query that i am using is

  Delete from tbl_directory where directoryid='10'

  Here tbl_directory is my table name.When this query gets executed a new record gets added in the databse with the same data as that of directory id 10.

  Plz help me as early as possible as that is an urgent requirement.

  Plz note that i have not used any trigger nor i have used any transaction

   

  Thanks

   

• sushila

  SSC-Dedicated

  Points: 35293

  More actions

  July 27, 2005 at 11:47 pm

  #577773

  that's weird! do you have any triggers set on this table ?! I think it maybe something in a trigger that just inserts the deleted row back!

  
  
  
  
  
  
  **ASCII stupid question, get a stupid ANSI !!!**

• surya-236315

  SSC Eights!

  Points: 850

  More actions

  July 28, 2005 at 8:21 am

  #577897

  are you running the query with in a transaction? If you are, then make sure that you commit the transaction.