Sort Detail Data Block Example - Oracle Forms

发布时间:2017-3-25 13:51:09 编辑:www.fx114.net 分享查询网我要评论
本篇文章主要介绍了"Sort Detail Data Block Example - Oracle Forms ",主要涉及到Sort Detail Data Block Example - Oracle Forms 方面的内容,对于Sort Detail Data Block Example - Oracle Forms 感兴趣的同学可以参考一下。

Sort Detail Data Block Example - Oracle Forms

Example is given below to sort detail data block data (toggle asc or desc) with push buttons used as header of grid, by setting ORDER_BY property of data block using SET_BLOCK_PROPERTY command.
 
The following is the screen shot of this example and this form can be downloaded from the below link:
Sort Detail data block example Oracle Forms
 
In this example two data block are being used, one is to contain push buttons to sort data and one is to hold the data in detail block.
 
On every push button of header the following code is written on When-Button-Pressed trigger:
Begin
 If Nvl(Get_Block_Property('scott_emp', order_by), 'ENAME ASC') = 'ENAME ASC' then
    Set_Block_Property('scott_emp', order_by, 'ename desc');
 Else    Set_Block_Property('scott_emp', order_by, 'ename asc');  End if;
 Go_Block('scott_emp');  Execute_Query;
End;

You see in above example when I am getting the current setting of order by property of the block, I am reading it in upper case because it returns in upper case even if I am setting the property in lower case.

上一篇:离散时间信号与系统:1
下一篇:编译FFmpeg成一个SO库<转>

相关文章

相关评论

本站评论功能暂时取消,后续此功能例行通知。

一、不得利用本站危害国家安全、泄露国家秘密,不得侵犯国家社会集体的和公民的合法权益,不得利用本站制作、复制和传播不法有害信息!

二、互相尊重,对自己的言论和行为负责。

好贷网好贷款