This content has been marked as final. Show 2 replies
Davadvice wrote:1. Are you sure the select is returning any rows?
i have a report based on
FROM (SELECT e.EMPNO ,e.JOB Job
FROM EMP E)X
can you advise why i'm getting Zero?
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.
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
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.
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.
Edited by: Davadvice on Jan 29, 2013 8:36 AM
Edited by: Davadvice on Jan 29, 2013 8:38 AM