There are many threads regarding this issue in the forum. Many of them without any answer. So, how do you add rows to your standard tabular form based on an item value?
If you follow this example:
http://apex.oracle.com/pls/otn/f?p=31517:209
you will see that you need three small adjustments to the standard process:
1. extend your SQL using UNION_ALL by adding a small SQL selecting NULL's from DUAL followed by CONNECT BY LEVEL <= :P1_ADD_ROWS_ITEM,
2. add a conditional branch, first in the sequence, passing a request ADD to your page
3. do a modification to the standard add rows process to add 0 rows
and there you go. You don't need to write a manual process to get that functionality
applied on your standard tabular form.
Enjoy.
No comments:
Post a Comment