chalie001
asked on
calendar in form 11g
hi how can i implement the calendar in my form 11g
Is there any error there ?
ASKER
no it does not show any error code
It is very strange. If you have done all as it is described in a link then you have to debug your form. I would begin in a when-button-pressed trigger of BTN_FORMS_DATE.
ASKER
i did that puting message('test');
it does not show
it does not show
Please, put here the code where is message('test');
ASKER
this the trigger code
message('8testt');
it does not show this msg when i press the button
message('8testt');
DECLARE
cur_x_pos INTEGER := 0;
cur_y_pos INTEGER := 0;
new_x_pos INTEGER := 0;
new_y_pos INTEGER := 0;
item_height INTEGER := 0;
my_date VARCHAR2(25);
BEGIN
message('testtt');
cur_x_pos := Get_Item_Property('CONTROL.FORMS_DATE',x_pos);
cur_y_pos := Get_Item_Property('CONTROL.FORMS_DATE',y_pos);
item_height := Get_Item_Property('CONTROL.FORMS_DATE',height);
message('testt09999t');
new_x_pos := cur_x_pos;
new_y_pos := cur_y_pos + item_height + 2;
Date_Lov.get_Date(display_date => sysdate
,return_item => 'CONTROL.FORMS_DATE'
,v_x_pos => new_x_pos
,v_y_pos => new_y_pos
,v_title => 'FORMS DATE PICKER'
,v_ok => 'OK'
,v_cancel => 'Cancel'
,V_highlight => FALSE
,v_autoconfirm => FALSE
,v_autoskip => FALSE
);
END;
it does not show this msg when i press the button
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
its still not working the form was in 6i upgraded to 11g and was running in linux i recompile it in window
If operation systems are different then form must be compiled on system where it runs. Also libraries (pll).
ASKER
I did compile in window other function of the from are working only the button function is not working
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I change that to my block item still the same
CALENDAR object was copied or subclassed ?
◾If you subclass – the CALENDAR.olb must be located in a directory listed in your FORMS_PATH
◾If you subclass – the CALENDAR.olb must be located in a directory listed in your FORMS_PATH
ASKER
Subclasses I did that is in form path
If I understand you have put
message('testtt');
pause;
in the beginning of When-button-pressed trigger of button, message is displayed but function Date_Lov.get_Date does nothing.
I would put
message('after calling function');
pause;
at the end of code(after function Date_Lov.get_Date ). If this message is displayed and calendar not, then I think there are 2 options:
1. debug - also function Date_Lov.get_Date
2. try it with copy instead of subclass
I really don't know what can be a problem.
message('testtt');
pause;
in the beginning of When-button-pressed trigger of button, message is displayed but function Date_Lov.get_Date does nothing.
I would put
message('after calling function');
pause;
at the end of code(after function Date_Lov.get_Date ). If this message is displayed and calendar not, then I think there are 2 options:
1. debug - also function Date_Lov.get_Date
2. try it with copy instead of subclass
I really don't know what can be a problem.
Have you changed also this to your block item ?
cur_x_pos := Get_Item_Property('CONTROL.FORMS_DATE',x_pos);
cur_y_pos := Get_Item_Property('CONTROL.FORMS_DATE',y_pos);
item_height := Get_Item_Property('CONTROL.FORMS_DATE',height);
cur_x_pos := Get_Item_Property('CONTROL.FORMS_DATE',x_pos);
cur_y_pos := Get_Item_Property('CONTROL.FORMS_DATE',y_pos);
item_height := Get_Item_Property('CONTROL.FORMS_DATE',height);
ASKER
am still checking what could be the problem
ASKER
Still not working
What is problem now ?
ASKER
message('testtt');
pause;
cur_x_pos := Get_Item_Property('CONTROL .FORMS_DAT E',x_pos);
pause;
cur_x_pos := Get_Item_Property('CONTROL
Here is a good link (it is for 10g):
https://sites.google.com/site/craigsoraclestuff/oracle-forms---how-to-s/forms-how-to-use-a-calendar-in-a-form