| 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: |
| Sorting Columns By Buttons; Oracle Forms 6i | |
|---|---|
| Tweet Topic Started: Jul 23 2010, 07:43 PM (123 Views) | |
| YouthHelp | Jul 23 2010, 07:43 PM Post #1 |
|
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; |
![]() |
|
| 1 user reading this topic (1 Guest and 0 Anonymous) | |
| « Previous Topic · Oracle Forms and Reports · Next Topic » |





![]](http://z2.ifrm.com/static/1/pip_r.png)



3:49 AM Jul 11