Home » Developer & Programmer » Forms » list item problem
list item problem [message #303076] Wed, 27 February 2008 21:56 Go to next message
salwa
Messages: 76
Registered: December 2007
Member
hi all
my column name AUTHORIZE_1_BY this is list item.
this code is ok for pre_form_trigger. but i need
(AUTHORIZE_1_BY) when mouse click or post change because
:global.module loded post change triger
plse help.

declare

v_rec recordgroup;
vstatus number;
v_user varchar2(35);
v_webid number;
v_branch number;
QT CHAR(1):= '''';
v_showalert number;
v_event number;

v_HOMEBRANCHID number;
v_WEBBRANCHID number;
rg_vv recordgroup ;

BEGIN

v_event:=to_number(:global.module||:global.submodule||:global.product||:global.operation||:global.mode||3 );


v_user:= 'u3' ;--ltrim(rtrim(:global.mk_user_name));
begin
select HOMEBRANCHID
into v_HOMEBRANCHID
from userinfo a
where a.username =v_user;
exception
when others then
message(sqlerrm);
message(sqlerrm);
end;

rg_vv :=find_group('v_rec');
if not id_null(rg_vv) then
delete_group(rg_vv);
end if;

v_rec := create_group_from_query('v_rec','SELECT distinct USERNAME, USERNAME FROM USERINFO ,USERROLE ,ROLERIGHTS ,RIGHTS WHERE USERINFO.ID = USERROLE.USERID AND ROLERIGHTS.RIGHTSID = RIGHTS.ID AND USERROLE.ROLEID = ROLERIGHTS.ROLEID AND USERINFO.HOMEBRANCHID ='||''''||v_HOMEBRANCHID||''''|| 'AND RIGHTS.ID = '||''''||v_event||'''');

if not id_null(v_rec) then

vstatus := populate_group(v_rec);
populate_list('FE_IMP_BILL.AUTHORIZE_1_BY',v_rec);

end if;

exception
when others then null;

END;

null;



Re: list item problem(plse help argent) [message #303109 is a reply to message #303076] Thu, 28 February 2008 00:35 Go to previous messageGo to next message
salwa
Messages: 76
Registered: December 2007
Member
hi all
my column name AUTHORIZE_1_BY this is list item.
this code is ok for pre_form_trigger. but i need
(AUTHORIZE_1_BY) when mouse click or post change because
:global.module load post change triger. so a donot find
:global.module pre_form_trigger
plse help.

declare

v_rec recordgroup;
vstatus number;
v_user varchar2(35);
v_webid number;
v_branch number;
QT CHAR(1):= '''';
v_showalert number;
v_event number;

v_HOMEBRANCHID number;
v_WEBBRANCHID number;
rg_vv recordgroup ;

BEGIN

v_event:=to_number(:global.module||:global.submodule||:global.product||:global.operation||:global.mode||3 );


v_user:= 'u3' ;--ltrim(rtrim(:global.mk_user_name));
begin
select HOMEBRANCHID
into v_HOMEBRANCHID
from userinfo a
where a.username =v_user;
exception
when others then
message(sqlerrm);
message(sqlerrm);
end;

rg_vv :=find_group('v_rec');
if not id_null(rg_vv) then
delete_group(rg_vv);
end if;

v_rec := create_group_from_query('v_rec','SELECT distinct USERNAME, USERNAME FROM USERINFO ,USERROLE ,ROLERIGHTS ,RIGHTS WHERE USERINFO.ID = USERROLE.USERID AND ROLERIGHTS.RIGHTSID = RIGHTS.ID AND USERROLE.ROLEID = ROLERIGHTS.ROLEID AND USERINFO.HOMEBRANCHID ='||''''||v_HOMEBRANCHID||''''|| 'AND RIGHTS.ID = '||''''||v_event||'''');

if not id_null(v_rec) then

vstatus := populate_group(v_rec);
populate_list('FE_IMP_BILL.AUTHORIZE_1_BY',v_rec);

end if;

exception
when others then null;

END;
Re: list item problem [message #303158 is a reply to message #303076] Thu, 28 February 2008 03:17 Go to previous messageGo to next message
Flash
Messages: 34
Registered: February 2008
Member
Question is not clear.
This is what I have understood. Please correct me if I am wrong.
You are able to do this code correctly in pre-form trigger. But on when mouse click you are getting some error

If you are getting any error messages, Please give us the error message along with the error code, so that we can help you out.
Re: list item problem [message #303621 is a reply to message #303158] Sat, 01 March 2008 03:55 Go to previous messageGo to next message
shekhar.salunkhe
Messages: 154
Registered: January 2008
Location: Pune
Senior Member
how can i make multile selection in list item in oracle forms 6i
Re: list item problem [message #303824 is a reply to message #303621] Sun, 02 March 2008 23:44 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Look at:
Selecting Multiple Values from LOV
http://forums.oracle.com/forums/message.jspa?messageID=590264#590264

David
Previous Topic: Paas parameter to report from forms10g
Next Topic: Add Own parameter in Formsweb.cfg
Goto Forum:
  


Current Time: Sat Dec 03 16:20:14 CST 2016

Total time taken to generate the page: 0.19278 seconds