8 Replies Latest reply: Nov 23, 2012 10:37 PM by zycoz100 RSS

    in  a tabular form created via wizard  can i use the following method.

    zycoz100
      Hi
      To change the value of a column..
      I create a following procedure ...

      declare
      count_em number;
      BEGIN
      FOR i in 1..APEX_APPLICATION.G_F01.count
      LOOP
      apex_application.g_f05(i) := 12;
      apex_application.g_f04(i) := 12;
      apex_application.g_f03(i) := 'ONEYEARI';
      END LOOP;


      END;

      04 Is start_Number column
      while end_number is 05
      And third column is offer .
      But the value donot get changed..

      The change donot get reflected in the database. . Any idea. .what am i doing wrong..
      Is this method of referencing values in tabular form a correct method..?
      Thanks again
      Thanks

      Edited by: zycoz100 on Oct 19, 2012 10:00 PM
        • 1. Re: in  a tabular form created via wizard  can i use the following method.
          Bas de Klerk
          Hi zycoz100 ,


          APEX version ??

          Are you running this as a "on submit-after computations and validations" process ?
          Did you check if this process is run ( for example by insert a test record in a table ) ?

          You can also check the logic by enabling debugging on the page and see if the process is being run (without errors).

          regards
          Bas
          • 2. Re: in  a tabular form created via wizard  can i use the following method.
            zycoz100
            Thanks .. I am using apex 4 ..Now just shifting my full app to apex 4.2
            Hope everything goes fine..
            And in apex 4 when i used composite index. i face issues like 1422 error ..
            So i will shift to 4.2 where this can be solved easily .I might use the rowid feature..


            Within a few moments i will try doing what you mentoined..
            shall take atleast 2 hours..
            Thanks
            • 3. Re: in  a tabular form created via wizard  can i use the following method.
              zycoz100
              Ok I tried it but without sucess..The value is found in the table..
              But the columns are not updated...

              The procedure is submited after computation and validation
              These are the values of debug

              ation "INVOICE_AMOUNT must be numeric" - Type: ITEM_IS_NUMERIC     4     

              0.02400     0.00000     ...Validation "NO_OF_ISSUES must be numeric" - Type: ITEM_IS_NUMERIC     4     

              0.02400     0.00000     Branch point: Before Processing     4     

              0.02400     0.00000     Processes - point: AFTER_SUBMIT     4     

              0.02400     0.00700     ...Process "ApplyMRU" - Type: MULTI_ROW_UPDATE     4     

              0.03100     0.00400     ......Row 1: insert into "FRIEND10"."SUBSCRIBERSV" ( "PRIMARY_KEY", "MAGAZINE_NO", "SUBSCRIBE_NO", "OFFER", "START_ISSUE", "END_ISSUE", "PAID_AMT", "INVOICE_AMOUNT", "NO_OF_ISSUES") values ( :b1, :b2, :b3, :b4, :b5, :b6, :b7, :b8, :b9)     4     

              0.03500     0.00100     ...Process "ApplyMRD" - Type: MULTI_ROW_DELETE     4     

              0.03600     0.00000     ......Skip because condition or authorization evaluates to FALSE     4     

              0.03600     0.00100     ...Process "pre_insert" - Type: PLSQL     4     

              0.03700     0.00000     ...Execute Statement: begin declare count_em number; BEGIN FOR i in 1..APEX_APPLICATION.G_F01.count LOOP apex_application.g_f05(i) := 12; apex_application.g_f04(i) := 12; apex_application.g_f03(i) := 'ONEYEARI'; END LOOP; END; end;     4     

              0.03700     0.00000     Branch point: After Processing     4     

              0.03700     0.00300     ...Evaluating Branch: "AFTER_PROCESSING" Type: REDIRECT_URL Button: (No Button Pressed) Condition: (Unconditional)     4     

              0.04000     0.00000     Redirecting to f?p=166:89:16134968923851:::::&success_msg=0%20row(s)%20updated%2C%201%20row(s)%20inserted.ss%2F892D9AA6C2BA9C6422AB2F7D4D2D5E2B%2F     4     

              0.04000     0.00000     Stop APEX Engine detected     4     

              0.04000     0.00000     Stop APEX Engine detected

              Edited by: zycoz100 on Oct 21, 2012 12:19 PM
              • 4. Re: in  a tabular form created via wizard  can i use the following method.
                DanielB
                the source property of the item is always substitute the value or only where is null?
                • 5. Re: in  a tabular form created via wizard  can i use the following method.
                  zycoz100
                  Thanks
                  My existing tabular report was based on a view using instead of ..trigger since the existing form had a composite key as a primarykey..
                  I had just redesigned my application to use only singular primary key..So i will redesign the form
                  The form will be based directly on table ..so i can see the source field

                  The source field attribute in my report attributes.
                  So i will just do the same and get back in a few minutes

                  Edited by: zycoz100 on Oct 21, 2012 5:54 PM
                  • 6. Re: in  a tabular form created via wizard  can i use the following method.
                    zycoz100
                    Hi Daniel,

                    The source property of the item is always substitute the value or only where is null

                    Since i am making a tabular form. .the reqion is reports
                    And in the cloumns i never found anything like source property..
                    Hope i am not missing anythign..
                    Thanks
                    • 8. Re: in  a tabular form created via wizard  can i use the following method.
                      zycoz100
                      i just opted out of apex multiple form insted used master detail..
                      My business requirment seems to work
                      Thanks again