Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2009
    Posts
    1

    Unanswered: forms 6i tabular layout data access

    hi All,

    I hav developed a form in forms 6i. This form is having one
    tabular layout data block say D1. No of records appearing in this datablock are 10 at a time.
    I hav a checkbox in this data block(D1). Now I hav a button on other manually created data block(D2).
    I want to update a column of table in the database on the click of this button for all checked box which are ticked....
    Now I hav to write a coding on this button(When_button_pressed)
    but i dont know how to loop and reach all those ticked checkbox of the other data block(D1) shown on the tabular layout..
    so wht is the coding that has to be done to identify all ticked checkbox of D1 on other button data block(D2)


    Puneet
    Last edited by Puneet Sanghal; 11-03-09 at 07:39. Reason: just correct

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    My Forms is rusty, but I think something like:
    Code:
    begin
       go_block('D1');
       first_record;
       loop
          if :d1.my_checkbox = 'Y' then
             -- do something;
             null;
          end if;
          exit when :SYSTEM.LAST_RECORD = 'TRUE';
          next_record;
       end loop;
    end;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •