Date Picker Calendar for Oracle Forms 6i

Source: Internet
Author: User

Giving date picker Calendar option to User for Date type fields in Oracle Forms. I am Providing you the form (FOXCAL.FMX) and the libraries (GENERAL.PLX and CALENDAR.PLL). You can download these files by clicking below Link:download Form and required PLLLike the US to get notifications for free source code in the future, thanks.
How to use It was very simple to use, no need to attache any library to your form, just copy all three files to your Curren T working directory of your application. Suppose you has a form and there is one or many date date type, the form. You had to create key-listval trigger for those date type fields or create a push button adjacent to those fields and pas Te the below code in when-button-pressed trigger:DECLARE
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 ());
add_parameter (pl_id, ' YPOS ', Text_parameter, To_char (+));
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 is 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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.