ora rodrigez
asked on
callander.pll
hi,
we are upgrading from oracle forms6i to forms12
and our calander control is not working, from what ihave understood from googling the error,
the problem is callander. pll problem, its too old...
can u please send me an updated pll.
thanks, ora
we are upgrading from oracle forms6i to forms12
and our calander control is not working, from what ihave understood from googling the error,
the problem is callander. pll problem, its too old...
can u please send me an updated pll.
thanks, ora
As I know there is no new version of this pll library there. What errors are there or what is not working ?
ASKER
It compiles but fail on get date func. on oracle forms6i it works good
Here is our get date function:
PROCEDURE get_date (display_date IN DATE
,return_item IN VARCHAR2
,v_x_pos IN NUMBER := 0
,v_y_pos IN NUMBER := 0
,v_title IN VARCHAR2 := 'Date List of Values'
,v_ok IN VARCHAR2 := 'OK'
,v_cancel IN VARCHAR2 := 'Cancel'
,v_highlight IN BOOLEAN := TRUE
,v_autoconfirm IN BOOLEAN := FALSE
,v_autoskip IN BOOLEAN := FALSE)
IS
date_window window;
BEGIN
date_window := find_window('date_lov_wind ow');
-- set date lov window position
set_window_property(date_w indow, position, v_x_pos, v_y_pos);
-- set date lov window title
set_window_property(date_w indow, title, v_title);
-- set OK button label
set_item_property('date_co ntrol_bloc k.ok_butto n',label,v _ok);
-- set Cancel button label
set_item_property('date_co ntrol_bloc k.cancel_b utton',lab el,v_cance l);
-- set date lov auto confirm flag
lov_auto_confirm := v_autoconfirm;
-- set date lov auto skip flag
lov_auto_skip := v_autoskip;
-- set weekend highlight flag
weekend_highlight := v_highlight;
date_lov_return_item := return_item;
set_day_labels;
display_cal(display_date);
go_block('date_control_blo ck');
END get_date;
Maybe this our opinion can help you:
We use callendar.pll in forms 11g. The library is not attached to the form but it's objects (DATE_CONTROL_BLOCK,DATE_B UTTON_BLOC K,DATE_LOV _CANVAS,DA TE_LOV_WIN DOW and PKG_CALENDAR (Package spes and body)) are directly in the form. We changed
-- copy(to_char(to_date(to_ch ar(pkg_cal endar.cur_ lov_date), 'MM/DD/RRR R')), pkg_calendar.date_lov_retu rn_item);
copy(to_char(pkg_calendar. cur_lov_da te,'DD.MM. YYYY'), pkg_calendar.date_lov_retu rn_item);
in the procedures date_click and date_choosen.
PROCEDURE get_date (display_date IN DATE
,return_item IN VARCHAR2
,v_x_pos IN NUMBER := 0
,v_y_pos IN NUMBER := 0
,v_title IN VARCHAR2 := 'Date List of Values'
,v_ok IN VARCHAR2 := 'OK'
,v_cancel IN VARCHAR2 := 'Cancel'
,v_highlight IN BOOLEAN := TRUE
,v_autoconfirm IN BOOLEAN := FALSE
,v_autoskip IN BOOLEAN := FALSE)
IS
date_window window;
BEGIN
date_window := find_window('date_lov_wind
-- set date lov window position
set_window_property(date_w
-- set date lov window title
set_window_property(date_w
-- set OK button label
set_item_property('date_co
-- set Cancel button label
set_item_property('date_co
-- set date lov auto confirm flag
lov_auto_confirm := v_autoconfirm;
-- set date lov auto skip flag
lov_auto_skip := v_autoskip;
-- set weekend highlight flag
weekend_highlight := v_highlight;
date_lov_return_item := return_item;
set_day_labels;
display_cal(display_date);
go_block('date_control_blo
END get_date;
Maybe this our opinion can help you:
We use callendar.pll in forms 11g. The library is not attached to the form but it's objects (DATE_CONTROL_BLOCK,DATE_B
-- copy(to_char(to_date(to_ch
copy(to_char(pkg_calendar.
in the procedures date_click and date_choosen.
ASKER
Can u send me all the sources?
Thanks
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks, i will check it on sunday. And i will update u.
Thanks a lot
Thanks a lot
This is functional callendar.pll.