1 Reply Latest reply: Jul 9, 2013 7:11 AM by François Degrelle RSS

    Time in List Item

    870213

      Oracle Developer Suite 10g

       

      I want to create List item with time .

      see picture http://www.orafaq.com/forum/m/589634/143553/#msg_589634

        • 1. Re: Time in List Item
          François Degrelle

          Create a List Item of type TList.

          At runtime, probably in the when-new-form-instance trigger, populate that list:

           

          PROCEDURE populate_list

          IS

              lc$hour  varchar2(10);

              k        pls_integer:=0;

          begin   

              clear_list('BLOCK3.LIST4');

              for i in 0 .. 23 loop

                  for j in 0 .. 59 loop

                      k := k + 1 ;

                      lc$hour := ltrim(to_char(i,'00')) || ':' || ltrim(to_char(j,'00'));

                      Add_List_Element('BLOCK3.LIST4', k , lc$hour, lc$hour ) ;

                  end loop;

              end loop;

          end;

          Francois