摘要：
A cursor acts logically as a pointer into a result set. You can move the cursor through the result set, processing each row, until you determine you are at the end of the result set. There are three t... 阅读全文
posted @ 2016-12-25 20:12
全威儒
阅读(280)
评论(0)
推荐(0)
摘要：
Suppose you want to populate a non-database data block with records manually in Oracle forms. This task can be done using a cursor. Below is the example given for hr.job_history table, where user in... 阅读全文
posted @ 2016-12-25 20:10
全威儒
阅读(425)
评论(0)
推荐(0)
摘要：
Suppose you want to read a file from D2k client and want to store its content in Oracle database. But if you will insert row by row from client to server it will take more time and increase lot of net... 阅读全文
posted @ 2016-12-25 20:08
全威儒
阅读(471)
评论(0)
推荐(0)
摘要：
Below is the example to read and import comma delimited csv file in oracle forms with D2k_Delimited_String package. This package is available in D2kdlstr.pll library.To download D2kdlstr.Pll Click Her... 阅读全文
posted @ 2016-12-25 20:07
全威儒
阅读(790)
评论(0)
推荐(0)
摘要：
The example given below for writing text file or CSV using Text_IO package from a tabular block in Oracle Forms. Suppose there is a tabular grid data block "Job_History" in your forms and you want... 阅读全文
posted @ 2016-12-25 20:04
全威儒
阅读(288)
评论(0)
推荐(0)
摘要：
Write Post-Query trigger for the block you want to fetch the field value for display item.ExampleBegin Select Ename into :datablock.dspname from emp where ecode = :datablock.ecode; -- Fi... 阅读全文
posted @ 2016-12-25 20:03
全威儒
阅读(236)
评论(0)
推荐(0)
摘要：
DISPLAY_ITEM built-in in Oracle D2k FormsDescriptionMaintained for backward compatibility only. For new applications, you should use theSET_ITEM_INSTANCE_PROPERTY built-in. DISPLAY_ITEM modifies an it... 阅读全文
posted @ 2016-12-25 20:01
全威儒
阅读(316)
评论(0)
推荐(0)
摘要：
When a query is open in the block, the Post-Query trigger fires each time Form Builder fetches a record into a block. The trigger fires once for each record placed on the block’s list of records. Usag... 阅读全文
posted @ 2016-12-25 20:00
全威儒
阅读(342)
评论(0)
推荐(0)
摘要：
See also: Why And When To Use Pre-Update and Pre-Insert Triggers In Oracle FormsPre-Update Fires during the Post and Commit Transactions process, before a row is updated in Oracle Forms. It fires once... 阅读全文
posted @ 2016-12-25 19:59
全威儒
阅读(1033)
评论(0)
推荐(0)
摘要：
Pre-Query trigger in Oracle D2k / Oracle Forms DescriptionFires during Execute Query or Count Query processing, just before Form Builder constructs and issuesthe SELECT statement to identify rows that... 阅读全文
posted @ 2016-12-25 19:57
全威儒
阅读(447)
评论(0)
推荐(0)
浙公网安备 33010602011771号