Sort Detail Data Block Example - Oracle Forms
原创QUANWEIRU 博主文章分类:Oracle EBS Form ©著作权
©著作权归作者所有:来自51CTO博客作者QUANWEIRU的原创作品,请联系作者获取转载授权,否则将追究法律责任
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:
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.
上一篇:Displaying Tabbed and Stacked Canvas Using Show_View In Oracle Forms
下一篇:Oracle Forms Execute_Query Example To Fetch The Records From Database
提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章
-
Oracle11g Data Guard--创建物理备库
Oracle 11g Data Guard 管理
oracle hive SQL