restrict LOV in multi-user environment? [message #142665] |
Mon, 17 October 2005 02:38 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
s4sam
Messages: 18 Registered: October 2005 Location: pakistan
|
Junior Member |
|
|
hi to all,
I am in a prob. for 3 days. i want to restrict the LOV that once the user selects a value from LOV it must not be shown in LOV again. I have used
declare
b boolean;
begin
post;
b := show_lov('ord_lov');
end;
in when-button-pressed. It works but in multiuser environment , when the same form is opened at more than one client's end , the form helds for 2nd user until 1st user closes the same form. Is there any way to handle this LOV restriction in multi-user environment. Help me plz
|
|
|
|
|
|
Re: restrict LOV in multi-user environment? [message #142892 is a reply to message #142857] |
Tue, 18 October 2005 04:46 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
s4sam
Messages: 18 Registered: October 2005 Location: pakistan
|
Junior Member |
|
|
Ihave used the 2nd option.
It solved my problem.
declare
rec_count number;
lAsk BOOLEAN :=FALSE;
begin
-- Change LOV's record group
set_lov_property('LOV_CODE',GROUP_NAME,'RGR_CODE_PART');
-- Call LOV
lAsk:=show_lov('LOV_CODE');
-- Come back LOV's record group
set_lov_property('LOV_CODE',GROUP_NAME,'RGR_CODE_FULL');
-- if value selected then removed it from second record group
if lAsk then
rec_count:=get_group_row_count('RGR_CODE_PART');
for j in 1..rec_count loop
if get_group_char_cell('RGR_CODE_PART.DESCRIPTION',j) = :products.description then
delete_group_row('RGR_CODE_PART',j);
exit;
end if;
end loop;
end if;
end;
Upd-mod: Add code tags.
[Updated on: Tue, 18 October 2005 17:51] by Moderator Report message to a moderator
|
|
|