2 Replies Latest reply: Jan 29, 2013 2:38 AM by 746761 RSS

    APEX apex_application.g_fxx Not returning Count

    746761
      Hi,

      i have a report based on

      SELECT apex_item.text(1,x.EMPNO)ssID
      ,apex_item.text(2,x.Job)JOBS
      FROM (SELECT e.EMPNO ,e.JOB Job
      FROM EMP E)X

      When i return apex_application.g_f01.COUNT i get Zero


      can you advise why i'm getting Zero?

      Any help on this would be great


      Thanks
      David
        • 1. Re: APEX apex_application.g_fxx Not returning Count
          riedelme
          Davadvice wrote:
          Hi,

          i have a report based on

          SELECT apex_item.text(1,x.EMPNO)ssID
          ,apex_item.text(2,x.Job)JOBS
          FROM (SELECT e.EMPNO ,e.JOB Job
          FROM EMP E)X
          can you advise why i'm getting Zero?
          1. Are you sure the select is returning any rows?
          2. Something is wrong with the submit process - you have rows but nothing is being submitted

          Where are you using APEX_APPLICTION.G_F01.COUNT? I have gotten good results in validations but not tried to use it elsewhere.
          • 2. Re: APEX apex_application.g_fxx Not returning Count
            746761
            Hi thanks for the Reply,

            Sorry, i was rushing out the office and never had the time to add l more detail.

            yes there are 2 records within the Table, these are displayed on the report/Form

            i'm using APEX 4.1.


            the Data that is returned is

            SSid ,Jobs
            kq096542, Low
            MV09666, Med

            i have a Text Area where i am returning the count from G_F01 and G_F02.

            this is a test page as i have a more complicated page i need to develop and wish to use the Array to itterate and write data to a table on submit.


            Edit:



            I have just found out what the issue apears to be. i was using a Dynamic action to perform the Page submit and although it appeared to be submitting the page without actualy having a branch to its self the array was not being populated. I think i have it sorted now.


            thanks
            David

            Edited by: Davadvice on Jan 29, 2013 8:36 AM

            Edited by: Davadvice on Jan 29, 2013 8:38 AM