Link to home
Start Free TrialLog in
Avatar of ora rodrigez
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
Avatar of Helena Marková
Helena Marková
Flag of Slovakia image

As I know there is no new version of this pll library there. What errors are there or what is not working ?
Avatar of ora rodrigez
ora rodrigez

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_window');

            -- set date lov window position
            set_window_property(date_window, position, v_x_pos, v_y_pos);

            -- set date lov window title
            set_window_property(date_window, title, v_title);

            -- set OK button label
            set_item_property('date_control_block.ok_button',label,v_ok);
            
            -- set Cancel button label
            set_item_property('date_control_block.cancel_button',label,v_cancel);

            -- 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_block');
      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_BUTTON_BLOCK,DATE_LOV_CANVAS,DATE_LOV_WINDOW and PKG_CALENDAR (Package spes and body)) are directly in the form. We changed
--                  copy(to_char(to_date(to_char(pkg_calendar.cur_lov_date),'MM/DD/RRRR')), pkg_calendar.date_lov_return_item);
                  copy(to_char(pkg_calendar.cur_lov_date,'DD.MM.YYYY'), pkg_calendar.date_lov_return_item);
in the procedures date_click and date_choosen.
Can u send me all the sources?
Thanks
ASKER CERTIFIED SOLUTION
Avatar of Helena Marková
Helena Marková
Flag of Slovakia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks, i will check it on sunday. And i will update u.
Thanks a lot
This is functional callendar.pll.