This discussion is archived
2 Replies Latest reply: Jan 29, 2013 12:38 AM by 746761 RSS

APEX apex_application.g_fxx Not returning Count

746761 Newbie
Currently Being Moderated
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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points