0 Replies Latest reply: Aug 21, 2013 12:45 AM by Phil in Sydney RSS

    How to Split/Bend a tabular into 3 parts in a Form?

    Phil in Sydney

      Hi Form Experts,

       

      My questions is how to split a tabular into 3 parts on the canvas.

      Say I have a table like following.

       

      create table a (

      id number,

      name varchar2(10)

      );

       

      insert into a values(1,'a');

      insert into a values(2,'b');

      insert into a values(3,'c');

      insert into a values(4,'d');

      insert into a values(5,'e');

      insert into a values(6,'f');

      insert into a values(7,'g');

      insert into a values(8,'h');

      insert into a values(9,'i');

       

      In a Form, I would like to show 'table a' in a tabular, but it was cut into 3 parts.

      It is like a 3x3 array.

      The first 3 records are displayed on the first column, the middle 3 records are in the 2nd column,the last 3 records are in the last column.

       

      1,a     4,d     7,g

      2,b     5,e     8,h

      3,c     6,f     9,i

       

      When I do the execute_query to this Text Item, I can use Key-up and Key-down to scroll the records.

       

      The reason why I want to make it, just because if the records cannot fit in one screen, I can bend it to the right side.

       

      Can you guys give me any hints or solutions?

       

      Appreciate in advance.

       

      Phil