1 Reply Latest reply: Apr 15, 2012 1:49 PM by HamidHelal RSS

    How to store the selected gruop of values in the FORMS

    893105
      I have one multi record Data Block in Forms. Every record contains one CHECKBOX. Each Record contains one Primary Key.

      Now, My Requirement is, while selecting the CHECKBOX i should add that record's primay key value to some ( collection / string)

      I will use this ( string or collection) in SQL query.

      If i use varchar variable to store those values. It will gives a problems if user unchecks any checked checkbox. we should remove its value from that string.

      How add and delete the values to the collection?
        • 1. Re: How to store the selected gruop of values in the FORMS
          HamidHelal
          Bhaskar wrote:
          If i use varchar variable to store those values. It will gives a problems if user unchecks any checked checkbox. we should remove its value from that string.

          How add and delete the values to the collection?
          try something like this..
          declare
          coll_string varchar2(20);
          
          begin
          if :check_box_value='yes' then
            coll_string:=123||:check_box_value;
          elsif :check_box_value='no' then
            coll_string:=123;
          end if;
          
          end;
          Hope this helps..

          Hamid