0 Replies Latest reply on Jun 7, 2007 4:43 PM by sherler8

    Check Detail Records Fails

    sherler8
      Can anyone shed some much needed light on 'Check Detail Records'. I cannot get it to work with any form configuration. Need it to work with the 'Create Dynamic Form Wizard'.

      The Delete function works fine if there is no detail record found, but if there is a detail record I get the following error:

      The error code:

      Error:
      An error occurred while deleting the records.
      Check detail record failed.
      Error Message
      Developer Details:
      tNG_multipleDelete error.
      An error occurred while deleting the records. (MDEL_ERROR)
      Check detail record failed. (TRIGGER_MESSAGE__CHECK_DETAIL_RECORD)
      tNG Execution Trace - VIEW

      * tNG_multipleInsert.executeTransaction
      o STARTER.Trigger_Default_Starter
      * tNG_multipleUpdate.executeTransaction
      o STARTER.Trigger_Default_Starter
      * tNG_multipleDelete.executeTransaction
      o STARTER.Trigger_Default_Starter
      o tNG_multipleDelete.doTransaction
      + tNG_multipleDelete.prepareSQL
      # tNG_delete.executeTransaction
      * STARTER.Trigger_Default_Starter
      * tNG_delete.doTransaction
      o BEFORE.Trigger_Default_saveData
      + tNG_delete.saveData
      o BEFORE.Trigger_CheckDetail*
      * tNG_multipleUpdate.getRecordset
      * tNG_multipleUpdate.getLocalRecordset

      Am at the desperate stage, if anyone can help. I have checked all obvious issues such as field names and accurate primary key. etc.

      Thanks