摘要：
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 ... 阅读全文
posted @ 2016-12-25 00:51
全威儒
阅读(550)
评论(0)
推荐(0)
摘要：
Execute_Query command is used to fetch all the records for current database data block in Oracle Forms, actually its executes query in current data block. SyntaxEXECUTE_QUERY; Clears the current bloc... 阅读全文
posted @ 2016-12-25 00:48
全威儒
阅读(1187)
评论(0)
推荐(0)
摘要：
In this post you will learn how to specify any condition in enter query mode of Oracle Forms. Whenever Enter_Query command executes Oracle Forms comes into enter query mode and in that mode you can s... 阅读全文
posted @ 2016-12-25 00:42
全威儒
阅读(467)
评论(0)
推荐(0)
摘要：
Log user's login and logout details in to table through Oracle Forms using POST-LOGON and PRE-LOGOUT triggers to track the user's login and logout activity for auditing purposes. In this example on... 阅读全文
posted @ 2016-12-25 00:33
全威儒
阅读(496)
评论(0)
推荐(0)
摘要：
An example given below for Oracle Forms, when a value exists then execute query for that value to display the correspondent record else allow user to create a new record for that value. The following... 阅读全文
posted @ 2016-12-25 00:25
全威儒
阅读(347)
评论(0)
推荐(0)
摘要：
Oracle Forms is having its default records filter, which we can use through Enter Query mode to specify some search criteria or to filter records before display, but you can also create your own filte... 阅读全文
posted @ 2016-12-25 00:18
全威儒
阅读(474)
评论(0)
推荐(0)
摘要：
Example is given below to create a data block based on From Clause query in Oracle Forms. The following are the steps: Create a data block manually and set the following properties: You can spe... 阅读全文
posted @ 2016-12-25 00:09
全威儒
阅读(579)
评论(0)
推荐(0)
摘要：
Example is given below to Populate a List Item in Oracle Forms using Create_Group_From_Query , Populate_List and Populate_Group command. In this example you can specify the query at run time to popula... 阅读全文
posted @ 2016-12-25 00:05
全威儒
阅读(479)
评论(0)
推荐(0)
浙公网安备 33010602011771号