1 Reply Latest reply: Apr 25, 2013 6:50 AM by 951830 RSS

    Excel to CI - Record Field Save Edit Handling

    980000
      Hi,

      I've set up the following.

      1. Connected PRODKIT_CI through Excel to CI
      2. Set Action as 'Update'
      3. Filled all the data including MIN_COMP and MAX_COMP fields as 1 and 1 respectively.
      4. Staged for Data Submission
      5. Submitted

      But the row was not processed and the error thrown was taken from
      PRODKIT_HEADER.PRODUCT_ID.SaveEdit

      If PRODKIT_HEADER.MIN_COMP < 1 Then
      Error (MsgGet(17830, 3812, "The Minimum Total Components must be greater than 0."));
      End-If;

      PRODKITHEADER is a Scroll - Level 0 record of the component PRODKIT_

      Kindly help me to figure out the problem.

      Thanks in Advance.
        • 1. Re: Excel to CI - Record Field Save Edit Handling
          951830
          Hi,

          If the PRODKIT_HEADER record is within the component, then it will always trigger when you trigger the CI. If you want to overwrite the error message then add the condition below. This will skip the error message if the save edit is triggered by the PRODKIT_CI component interface

          If %compintfcname = "PRODKIT_CI" then
          Else
          If PRODKIT_HEADER.MIN_COMP < 1 Then
          Error (MsgGet(17830, 3812, "The Minimum Total Components must be greater than 0."));
          End-If;
          End-if;


          thanks,