InvisionFree - Free Forum Hosting
Fully Featured & Customizable Free Forums

Learn More · Sign-up for Free
Welcome to [Shephard Family Enterprise Consultants]. 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:

Name:   Password:


 

 Sorting Columns By Buttons, Oracle Forms 6i
YouthHelp
Posted: Jul 23 2010, 07:43 PM


Advanced Member


Group: Members
Posts: 49
Member No.: 51
Joined: 24-July 07



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;
Top
0 User(s) are reading this topic (0 Guests and 0 Anonymous Users)
0 Members:
« Next Oldest | Oracle Forms and Reports | Next Newest »
InvisionFree - Free Forum Hosting
Free Forums with no limits on posts or members.
Learn More · Register Now

Topic Options



Hosted for free by InvisionFree* (Terms of Use: Updated 2/10/2010) | Powered by Invision Power Board v1.3 Final © 2003 IPS, Inc.
Page creation time: 0.1745 seconds | Archive