Sort Detail Data Block Example - Oracle Forms
2024-09-29 19:20:01
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:
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.
最新文章
- day7_subprocess模块和面向对象,反射
- 关于GridView中控件的问题
- 在ie浏览器，360浏览器下，margin：0 auto；不居中的原因
- web项目总结——通过jsp+servlet实现对oracle的增删改查功能
- [ActionScript 3.0] 分页排版
- 前台传参数时间类型不匹配:type 'java.lang.String' to required type 'java.util.Date' for property 'createDate'
- 用Win7自带的磁盘管理工具给硬盘分区
- SSH框架构建微信公众帐号服务器小技巧
- IOS s数据存储之归档解档
- task-clph
- Flash与IE奇怪的关键字冲突
- 使用PSSH批量SSH操作Linux服务器
- 【转】windows7 64位系统认不出8g内存显示只有3G可用
- Vue的报错：Uncaught TypeError: Cannot assign to read only property 'exports' of object '#<Object>'
- PaddlePaddle︱开发文档中学习情感分类（CNN、LSTM、双向LSTM）、语义角色标注
- openlayers三：添加图片和图标
- 一个.net的程序员如何转到java的?
- [React] immutable.js
- python爬虫 scrapy框架（一）爬取壁纸照片
- 利用DNSlog回显Weblogic(CVE-2017-10271) 漏洞执行命令结果