APEX

Hi,

I am trying to build a manual MRU form based on the How to tutorial by Christina Cho.

The differences are that I am using Apex 2.2 and thus apex_item functions and that I am putting the insertion row first before the existing rows (I want most recent records first).

To simplify testing I removed the select for the existing records (there are none so far). I have the following select:

select x.problem_id,
x.person_id,
x.probcode,
x.resolved,
x.diag_date,
x.resolved_date,
x.record_status
from (
select apex_item.hidden(1,null) problem_id,
apex_item.hidden(2,:p235_person_id) person_id,
apex_item.popupkey_from_query(3,null,
'select probcode||'' - ''||description d,
probcode from problist',75,75) probcode,
apex_item.select_list(5, '1','-;1, Yes;2') resolved,
apex_item.date_popup(6, null, null, :pick_date_format_mask, null, 12) diag_date,
apex_item.date_popup(7, null, null, :pick_date_format_mask, null, 12) resolved_date,
apex_item.hidden(8, 'ACT') record_status,
apex_item.md5_checksum(null, null, null, null, null, null) cks
from dual
) x

With the apex_item.hidden, the counts apex_application.g_f01, apex_application.g_f02, and apex_application.g_f08 are equal to zero(0) when I submit the data entered. If I change the hidden functions to text functions then the counts are equal to one(1).

The bad counts appear to be screwing up the collection creation procedure too; I expect it has to do with having a null for a loop end point..

I expect that I can create a work-around with the text fields and not showing them in the report, but does the hidden function have a real bug?

Also, for the collection creation routine, what can be done when there is nothing in the arrays? What is the value of the count?

thanks,
Peter