摘要：
CHECKBOX_CHECKED built-in in Oracle D2k FormsDescriptionA call to the CHECKBOX_CHECKED function returns a BOOLEAN value indicating the state of thegiven check box. If the item is not a check box, Form... 阅读全文
posted @ 2016-12-25 17:36
全威儒
阅读(424)
评论(0)
推荐(0)
摘要：
Suppose you want to give an option to user to select only 5 check boxes from given any number of check boxes in an Oracle Form and if user selects more than 5 than give a message that you can not sele... 阅读全文
posted @ 2016-12-25 17:33
全威儒
阅读(187)
评论(0)
推荐(0)
摘要：
Check Box Mapping of Other Values specifies how any fetched or assigned value that is not one of the pre-defined "checked" or "unchecked" values should be interpreted. Means suppose you have specifie... 阅读全文
posted @ 2016-12-25 17:30
全威儒
阅读(572)
评论(0)
推荐(0)
摘要：
Giving date picker calendar option to user for date type fields in Oracle Forms. I am providing you the form (FoxCal.Fmx) and two libraries (General.plx and Calendar.pll). You can download these files... 阅读全文
posted @ 2016-12-25 17:20
全威儒
阅读(559)
评论(0)
推荐(0)
摘要：
I have already posted and provided the required PLSQL Library and the Calendar FMX file in my previous blog post Date Picker Calendar For Oracle Forms but some people were still not able to use this ... 阅读全文
posted @ 2016-12-25 17:19
全威儒
阅读(570)
评论(0)
推荐(0)
摘要：
Below is the example to create an excel file in Oracle Forms.Pass the Sql query string to the below procedure to generate an Excel file using Ole2 package.PROCEDURE Create_Excel_File (CSQL Varchar2)Is... 阅读全文
posted @ 2016-12-25 17:14
全威儒
阅读(915)
评论(0)
推荐(0)
摘要：
Below is the some useful commands of Ole2 to format excel file in Oracle Forms.-- Change font size and name in ole2-- Declare as cfont ole2.obj_type;CFONT := OLE2.GET_OBJ_PROPERTY(CELL, 'Font');OLE2.S... 阅读全文
posted @ 2016-12-25 17:10
全威儒
阅读(1331)
评论(0)
推荐(0)
摘要：
Sharing a form to generate Excel file report from SQL query in Oracle Forms. This form can be used in Oracle Forms 6i and 10g / 11g. Below is the screen shot of this form and could be download from ... 阅读全文
posted @ 2016-12-25 17:08
全威儒
阅读(537)
评论(0)
推荐(0)
摘要：
An example is given below to how to create a modal dialog window in Oracle Forms for asking user input and return the value to any text item. The following is the screen shot of this demo and this f... 阅读全文
posted @ 2016-12-25 16:59
全威儒
阅读(526)
评论(0)
推荐(0)
摘要：
I have already posted in my previous post Running Reports Using Run_Product to run reports in Oracle Forms 6i and in this post I am using the same procedure to run report but I am providing a demo for... 阅读全文
posted @ 2016-12-25 16:55
全威儒
阅读(372)
评论(0)
推荐(0)
浙公网安备 33010602011771号