Link to home
Start Free TrialLog in
Avatar of chalie001
chalie001

asked on

calendar in form 11g

hi how can i implement the calendar in my form 11g
Avatar of Helena Marková
Helena Marková
Flag of Slovakia image

Implementation of calendar in 11g form is the same as it is in forms 6i, 10 g ...
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
Avatar of chalie001
chalie001

ASKER

i did that but the calendar does not pop up when i click the button,nothin happen
User generated image
Is there any error there ?
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.
i did that puting message('test');
it does not show
Please, put here the code where is message('test');
this the trigger code
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;

Open in new window


it does not show this msg when i press the button
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
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).
I did  compile in window  other function of the from are working only the button function is not working
ASKER CERTIFIED SOLUTION
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
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
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.
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);
am still checking what could be the problem
Still not working
What is problem now ?
message('testtt');
pause;
cur_x_pos := Get_Item_Property('CONTROL.FORMS_DATE',x_pos);