Thanks .. I am using apex 4 ..Now just shifting my full app to apex 4.2
Hope everything goes fine..
And in apex 4 when i used composite index. i face issues like 1422 error ..
So i will shift to 4.2 where this can be solved easily .I might use the rowid feature..
Within a few moments i will try doing what you mentoined..
shall take atleast 2 hours..
0.03700 0.00000 ...Execute Statement: begin declare count_em number; BEGIN FOR i in 1..APEX_APPLICATION.G_F01.count LOOP apex_application.g_f05(i) := 12; apex_application.g_f04(i) := 12; apex_application.g_f03(i) := 'ONEYEARI'; END LOOP; END; end; 4
My existing tabular report was based on a view using instead of ..trigger since the existing form had a composite key as a primarykey..
I had just redesigned my application to use only singular primary key..So i will redesign the form
The form will be based directly on table ..so i can see the source field
The source field attribute in my report attributes.
So i will just do the same and get back in a few minutes