2 Replies Latest reply on Aug 20, 2013 3:45 PM by katherine

    problem with overwriting the default delete procedure

    katherine

      Hi,

       

      I would like to overwrite the default delete procedure.

       

      Here is my procedure:

       

       

      FOR EACH ROW

      BEGIN ATOMIC

      DELETE FROM NativeModel.FIELD WHERE ("NEW".field_name = NativeModel.FIELD.NAME) AND ("NEW".project_name = NativeModel.FIELD.PROJECT_ID);

      END

       

       

      However, I got the following build error:

       

      ERROR: TEIID31119 Symbol "NEW".field_name is specified with an unknown group context

       

      What is wrong? Please help.

       

      Thank you.

       

      Katherine