Home » RDBMS Server » Server Administration » MULTISELECT with SHIFT+, CTRL+
MULTISELECT with SHIFT+, CTRL+ [message #370774] Fri, 04 February 2000 03:17 Go to next message
josef cihal
Messages: 12
Registered: January 2000
Junior Member
Help me please!!!
I need to select two or more rows (MULTISLECT)in the data block with using SHIFT+,CTRL+. This can I store in the RecordGroup. But I need to find code programming for this, because it is to hardly to programming this.
Thanks very much
josef cihal
Re: MULTISELECT with SHIFT+, CTRL+ [message #370846 is a reply to message #370774] Tue, 15 February 2000 23:28 Go to previous message
Amit Chauhan
Messages: 74
Registered: July 1999
Member
Hi,
You can do this by changing the visual attribute of the record selected. Use this code in the when-mouse-click trigger :
declare
l_cur_block varchar2(50) := :system.cursor_block;
l_cur_item varchar2(50);
l_cur_item_id item;
begin
l_cur_item varchar2(50) := l_cur_block || '.' ||get_block_property(l_cur_block, first_item);

if :system.mouse_button_shift_state = 'CNTRL+' then

l_cur_block := l_cur_block||'.';
while l_cur_item l_cur_block
loop
l_cur_item_id := find_item(l_cur_item);
if get_item_property(l_cur_item_id,displayed) = 'TRUE'
and get_item_property(l_cur_item_id,item_type) in
('CHECKBOX','LIST','RADIO GROUP','TEXT ITEM')
then
set_item_instance_property(l_cur_item_id,:system.cursor_record,visual_attribute,<VISUAL_ATTRIBUTE_NAME>);
end if;
l_cur_item := l_cur_block||get_item_property(l_cur_item,nextitem);
end loop;
end if;

end;

Same you can do for SHIFT+.

Hope this is helpful.

Thanks
Amit
Previous Topic: SQL Select number rows
Next Topic: help
Goto Forum:
  


Current Time: Wed Oct 21 11:52:33 CDT 2020