首页 > 代码库 > Date Picker Calendar For Oracle Forms 6i
Date Picker Calendar For Oracle Forms 6i
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 by clicking below link:
Download Form and required PLL
Like us to get notifications for free source code in future, thanks.<iframe title="fb:like Facebook Social Plugin" style="box-sizing: border-box; margin-bottom: 15px; border-top: medium none; height: 20px; border-right: medium none; width: 450px; border-bottom: medium none; position: absolute; border-left: medium none; visibility: visible" height="1000" src="https://www.facebook.com/v2.4/plugins/like.php?action=like&app_id=218168578325095&channel=http%3A%2F%2Fstaticxx.facebook.com%2Fconnect%2Fxd_arbiter%2Fr%2FiPrOY23SGAp.js%3Fversion%3D42%23cb%3Df2ce2c7ec9ea42%26domain%3Dwww.foxinfotech.in%26origin%3Dhttp%253A%252F%252Fwww.foxinfotech.in%252Ff29b32517a35288%26relation%3Dparent.parent&container_width=640&href=https%3A%2F%2Fwww.facebook.com%2Ffoxinfotech2014&layout=standard&locale=en_US&sdk=joey&share=false&show_faces=false" frameborder="0" width="1000" allowtransparency name="f20e9014e7823cc" scrolling="no" allowfullscreen="true"></iframe>
How To Use
It is very simple to use, no need to attache any library to your form, just copy all three files to your current working directory of your application. Suppose you have a form and there is one or many date date type fields in the form. You have to create key-listval trigger for those date type fields or create a push button adjacent to those fields and paste the below code in when-button-pressed trigger:
pl_id paramList;
begin
:GLOBAL.G_LOV_DATE := TRUNC(SYSDATE);
pl_id := Get_Parameter_List(‘foxcal‘);
IF NOT Id_Null(pl_id) THEN
destroy_parameter_list(pl_id);
end if;
pl_id := create_parameter_list(‘foxcal‘);
add_parameter(pl_id, ‘XPOS‘, text_parameter, to_char(50));
add_parameter(pl_id, ‘YPOS‘, text_parameter, to_char(100));
add_parameter(pl_id, ‘CURRDATE‘, text_parameter, to_char(Sysdate));
add_parameter(pl_id, ‘Label‘, text_parameter, ‘Date Picker‘);
CALL_FORM(‘foxcal‘, no_hide, do_replace, query_only, no_share_library_data, pl_id);
:yourdateitem := :Global.G_LOV_Date;
erase(‘Global.G_LOV_DATE‘);
END;
Note: Your current working directory for form designer and runtime should be the directory where you copied the above mentioned three files.
Download the demo form from the following link Date Picker Demo
See also: Oracle Forms Recipes
Date Picker Calendar For Oracle Forms 6i
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。