Скачать или смотреть Oracle Forms | How To Set Calendar With Jar File & Dynamic Date | Bangla (17 )

Oracle Forms | How To Set Calendar With Jar File & Dynamic Date
To See More Forms Tutorial Click here    • Oracle Forms: How to Install Oracle Databa...  
To See More Reports Tutorial Click here    • Introduction To Database & Out Line The Se...  

Dear viewer, In this video you will learn how to set easily CALENDAR at run time in Oracle forms & Show SYSDATE at run time.

CODE FOR FUNCTION:
FUNCTION custitemevent RETURN date IS
hBeanEventDetails ParamList;
eventName varchar2(80);
paramType number;
eventType varchar2(80);
newDateVal varchar2(80);
newDate date := null;
begin
hBeanEventDetails := get_parameter_list(:system.custom_item_event_parameters);
eventName := :system.custom_item_event;
if(eventName = 'DateChange') then
get_parameter_attr(hBeanEventDetails, 'DateValue', ParamType, newDateVal);
newDate := to_date(newDateVal,'DD.MM.RRRR');
-- else
-- MsgBox.show(MsgBox.STOP_ALERT,'Uknown event received - ' || eventName);
end if;
return newDate;
end;

CODE FOR TRIGGER:
declare
newdate date;
begin
newdate := custitemevent;
if (newdate is not null) then
:ORDERS.ORDER_DATE:= newdate;
end if;
end;

CODE FOR Implementation Class :
oracle.forms.demos.CalendarWidgetWrapper

To Get more Tutorial Subscribe The Channel
click here    / @oracledbsolutions2678  

To Get All Post Like The Facebook Page
Click here   / oracledbsolutions  

Follow us:
Facebook:   / oracledbsolutions  
Youtube link:    / @oracledbsolutions2678  
Facebook Group:   / 465557066961548  

Contact us:
email: [email protected]
Skype: oracle26solutions
Mob: 01734557080, 01627422780