Post reply

hidden rows

  • October 27, 2003 at 1:49 pm

    #160076

    I have a problem. I am trying to delete a record from one of my tables and it says the it can not be deleted because the subquery returned more than 1 value. The weird thing is that when I do a select only one record comes up. How can I delete this row? Any help is greatly appreciated.

    Thank you,

    Belinda

  • October 27, 2003 at 1:51 pm

    #479762

    Can you post the statement

  • October 27, 2003 at 1:55 pm

    #479763

    The statement I am using to delete is:

    delete from resources where contactid = 9542

    and if I do a select with the same contactid only one record appears.

  • October 27, 2003 at 1:58 pm

    #479764

    Any triggers that are being fired off?

    Guarddata-

  • October 27, 2003 at 2:05 pm

    #479766

    Yes two delete, two inserts, and one update. All to different tables.

  • October 27, 2003 at 2:05 pm

    #479765

    Which one contains a subquery!

  • October 27, 2003 at 2:51 pm

    #479776

    One of the delete triggers were causing the error. Once I disabled the trigger I was abe to delete the row. Thank you all for your help.

  • October 27, 2003 at 3:58 pm

    #479787

    You may need to have a look while the sub query is returning multiple records else someone is bound to run into the same problem again.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply