Home » Developer & Programmer » Forms » how to select all check boxes with single click (Forms 6i)
how to select all check boxes with single click [message #360884] Mon, 24 November 2008 04:28 Go to next message
nasir_mughal
Messages: 122
Registered: April 2007
Location: Karachi
Senior Member
Hi.


I have created a check box item "S" for selection of records in a tabular block with 14 records.

Please help me how can i achieve this.

1) how can i select/Deselect all queried records at once. In other words how can i check all check boxes at once.
2) How can I insert selected records in another table.



Thanks in advance.
Re: how to select all check boxes with single click [message #360891 is a reply to message #360884] Mon, 24 November 2008 04:47 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
"In a LOOP" is the answer to both of your questions.
Re: how to select all check boxes with single click [message #360893 is a reply to message #360891] Mon, 24 November 2008 04:52 Go to previous messageGo to next message
nasir_mughal
Messages: 122
Registered: April 2007
Location: Karachi
Senior Member
Thanks Sir for your response,

Will you explain little more or can provide code for LOOP.


Thanks.
Re: how to select all check boxes with single click [message #360898 is a reply to message #360893] Mon, 24 November 2008 05:18 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
WHEN-BUTTON-PRESSED trigger might look like this (checkbox = 1 when an item is checked):
go_block('some_block');
first_record;
   
loop
  :some_block.checkbox_item := 1;
 	  
  if :system.last_record = 'FALSE' 
  then
     next_record;
  else
     exit;
  end if;
end loop;

Insert would look the same; you'd just substitute ":some_block.checkbox_item := 1;" with an INSERT statement.
Re: how to select all check boxes with single click [message #360899 is a reply to message #360898] Mon, 24 November 2008 05:22 Go to previous message
nasir_mughal
Messages: 122
Registered: April 2007
Location: Karachi
Senior Member
Thank You Sir.
Previous Topic: Loading XLS file into forms
Next Topic: Clear Record
Goto Forum:
  


Current Time: Fri Feb 07 20:52:04 CST 2025