none
Update query problem RRS feed

  • Question

  • i want make update query

    UPDATE [dbo].[F_DOCLIGNE]
       SET 
          DO_Piece='ABL30503'
         
     WHERE DO_Piece='ABC30503'
    GO

    and  i faced this error

    Msg 82086, Niveau 11, État 1, Procédure TG_UPD_F_DOCLIGNE, Ligne 42
    L'entête de document n'existe pas !

    and i thought this table has a superior table to herit from

    it is F_DOCENTETE so i creat that number in F_DOCENTETE and the error still persist

    please help

    Monday, June 24, 2019 7:44 AM

Answers

  • ...déclencheurs..

    That's why I advocate for using plain English development and management systems..

    • Marked as answer by Houssem12 Tuesday, June 25, 2019 2:08 PM
    Tuesday, June 25, 2019 1:26 PM

All replies

  • There is an UPDATE trigger active, which is causing that error. You need to look into the trigger. Seems like that someone had chosen trigger integrity checks over referential checks.
    Monday, June 24, 2019 11:03 AM
  • i think there is a column should have the same value from a parent table

    if is true how ican verified

    Monday, June 24, 2019 1:03 PM
  • Again: You need to look into the trigger.
    Monday, June 24, 2019 2:25 PM
  • what is the trigger
    Monday, June 24, 2019 4:15 PM
  • Your error indicates your update is failing in a trigger named TG_UPD_F_DOCLIGNE.  You need to look at that trigger and see why it is failing.

    My guess would be you are not allowed to change DO_Piece.

    Monday, June 24, 2019 4:44 PM
  •  I have another application that can do but i am think there is another column in wich have the new DO_Piece and another column should exist in same time so i am looking for right now and testing

    and i am thinking if there any methode to extract that trigger or any procedure make this in first place.

    Tuesday, June 25, 2019 8:40 AM
  • First of all: Why using bold text? There is nothing such important about your posts..

    Then: What are your tools? Do you use SSMS? Just navigate in SSMS to the table, expand it and the trigger node. Then you can use the context menu..

    Tuesday, June 25, 2019 11:09 AM
  • please after modify what i can find

    and in my case i have no modify i have in french 'reorganiser'

    Tuesday, June 25, 2019 1:21 PM
  • ...déclencheurs..

    That's why I advocate for using plain English development and management systems..

    • Marked as answer by Houssem12 Tuesday, June 25, 2019 2:08 PM
    Tuesday, June 25, 2019 1:26 PM
  • thank you a lot this is what i want exactly

    thank you a lot again

    Tuesday, June 25, 2019 2:09 PM