9 Replies Latest reply on Dec 1, 2017 7:24 AM by Paulus Paulus

    Virtual Procedure to update data into table is not working

    Paulus Paulus Newbie

      DEAR ALL,

       

      Using Eclipse Teiid Designer, choose to create model, then select "relational view model", then choose to transform a existing model. That will create views for all the tables in that model selected.

       

      Now I am following below steps

       

      - Double click tblItems view

      - Checked the checkbox 'Supports Update'

      - Goto Insert tab

      - Unchecked 'Use Default' checkbox

      - Creating instead of trigger as below

           CREATE TRIGGER ON LetterTable

           INSTEAD OF UPDATE

           AS

           FOR EACH ROW     (QUERY)   END

       

      But when I save, all the contents goes away except first 3 lines.(

      CREATE TRIGGER ON LetterTable

           INSTEAD OF UPDATE

           AS)