Welcome Guest [Log In] [Register]
Welcome to [SHEPHARD FAMILY ENTERPRISE LLC]. We hope you enjoy your visit.


You're currently viewing our forum as a guest. This means you are limited to certain areas of the board and there are some features you can't use. If you join our community, you'll be able to access member-only sections, and use many member-only features such as customizing your profile, sending personal messages, and voting in polls. Registration is simple, fast, and completely free.


Join our community!


If you're already a member please log in to your account to access all of our features:

Username:   Password:
Add Reply
Sorting Columns By Buttons; Oracle Forms 6i
Topic Started: Jul 23 2010, 07:43 PM (123 Views)
YouthHelp
Advanced Member
[ *  *  * ]
PRE-QUERY (Block level - Parameter code to accommodate WHEN-BUTTON-PRESSED;

begin
if :global.first_time = 1 then
set_block_property('RR_EMPLOYER_CC_VW1',ORDER_BY,'COMPANY_NAME asc');
else
IF :PARAMETER.BLOCK_ORDER_BY = 'DESC' THEN
:PARAMETER.BLOCK_ORDER_BY := 'ASC';
ELSIF :PARAMETER.BLOCK_ORDER_BY = 'ASC' THEN
:PARAMETER.BLOCK_ORDER_BY := 'DESC';
ELSE
--:PARAMETER.FIELD_ORDER_BY := 'JOB_ORDER_ID';
:PARAMETER.BLOCK_ORDER_BY := 'DESC';
END IF;
set_block_property('RR_EMPLOYER_CC_VW1',ORDER_BY,:PARAMETER.FIELD_ORDER_BY||' '||
:PARAMETER.BLOCK_ORDER_BY);
end if;
end;

WBP
COMPANY_NAME


begin
COPY('COMPANY_NAME','PARAMETER.FIELD_ORDER_BY');
:global.first_time := 0;
go_block('RR_EMPLOYER_CC_VW1');
EXECUTE_QUERY;
end;



RR_SEQ_ID
begin
COPY('substr(rrid, 11, 4)','PARAMETER.FIELD_ORDER_BY');--SUJIT (CSR 9897, WR 6388 IR 4644)
:global.first_time := 0;
go_block('RR_EMPLOYER_CC_VW1');
EXECUTE_QUERY;
end;
Offline Profile Quote Post Goto Top
 
1 user reading this topic (1 Guest and 0 Anonymous)
« Previous Topic · Oracle Forms and Reports · Next Topic »
Add Reply