Hi guys!
Thanks to Martin Giffy D'Souza on Oracle APEX: Custom Code for Tabular Forms (Part 1) we know how to manually manage a tabular forms processes (except deleting, Martin ))) .
But i've been trying to go futher (but not succeded). Look, i try to use dynamically formed column in tabular for examle:
select empno, ename, APEX_ITEM.TEXT(p_idx=>3,p_value=>sal) as sal from EMP
So in design time i set empno to hidden (save states), ename column to text field and sal to plain text (but it looks in tabular form as text field of course).
While using Martin's technique in process of submitting (Execution Scope - All submitted rows) i have success with
update emp set ename = :ename where empno = :empno;
but not with
update emp set sal = :sal where empno = :empno; (with Cell in row 1 is empty)
So my hope is that i somehow break tabular parsing order with my bad APEX_ITEM.TEXT and should use little other APEX_ITEM.TEXT call. In fact i try to dynamically set a tabular form column type (in run time, not in design one). That's my goal.
What's about idea's to solve it, guys?