| list item problem [message #303076] |
Wed, 27 February 2008 21:56  |
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  |
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 |
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.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
