Hi,
I want a calendar when i press a button to select the date to execute the query on a particular date..please let me know.please let me know what the code to write.It will be a great help.
Thanks
Murali
Printable View
Hi,
I want a calendar when i press a button to select the date to execute the query on a particular date..please let me know.please let me know what the code to write.It will be a great help.
Thanks
Murali
Check out the calender supplied with Forms.
Hi
You can use Attached libraries.The name of the file is
Calender.pll
Regards,
Quote:
Originally posted by santoshym
Hi
You can use Attached libraries.The name of the file is
Calender.pll
Regards,
I tried this by attaching the calendar.pll to my module.it is giving the following error.
FRM-40105 UNABLE TO RESOLVE REFERENCE TO ITEM DATE BUTTON....
AND IT GOES ON GIVING ERROR FOR 36 BUTTONS.
PLEASE HELP ME OUT.LET ME KNOW THE PROCEDURE HOW ABOUT DOING IT.IT WILL BE A GREAT HELP
Hi Rao,
Try these steps
1) Go to Object library,Click Open,Select file type *.olb
Look for or search for
stndrd20.olb
2) Select Tools -> Object library
Select Component Tab.
Drag calender & drop it on an object group select copy
3) Select Attached libraries -> Create
Look for or search for
Calender.pll
click open
Attach, Select No
4) Go to Program -> Compile All
On Error
Copy(To_chardate_lov.current_lov_date),date_lov.date_return_item);
Go_item(Date_lov.date_lov_retrun_item);
Close window and repeat same for the other errors.
5) Goto Canvas,Create and name it as First
6) Goto datablock Create manually.Go to Layout editor and place a text item.
7) For the text item write the following trigger
Trigger Name : key-listval
Trigger Text :
Date_lov.get_data(sysdate,':block3.text_item4',240,60,'Ok','Cancel',true,false,false);
8) Compile the form & Save
9) Execute the form
Hope this helps
Regards,
Quote:
Originally posted by santoshym
Hi Rao,
Try these steps
1) Go to Object library,Click Open,Select file type *.olb
Look for or search for
stndrd20.olb
2) Select Tools -> Object library
Select Component Tab.
Drag calender & drop it on an object group select copy
3) Select Attached libraries -> Create
Look for or search for
Calender.pll
click open
Attach, Select No
4) Go to Program -> Compile All
On Error
Copy(To_chardate_lov.current_lov_date),date_lov.date_return_item);
Go_item(Date_lov.date_lov_retrun_item);
Close window and repeat same for the other errors.
5) Goto Canvas,Create and name it as First
6) Goto datablock Create manually.Go to Layout editor and place a text item.
7) For the text item write the following trigger
Trigger Name : key-listval
Trigger Text :
Date_lov.get_data(sysdate,':block3.text_item4',240,60,'Ok','Cancel',true,false,false);
8) Compile the form & Save
9) Execute the form
Hope this helps
I got the date lov button working.Thanks very much.it was easy.i have got one more problem.I have to execute the query when i select the particular date i.e search condition.
I have controls item like order date,order no,pseudo key,ship date.when i select the date,i should get the details related to order no,order date,pseduo key,ship date.please help me out in this matter.
thanks
Regards,
Quote:
Originally posted by rao
Quote:
Originally posted by santoshym
Hi Rao,
Try these steps
1) Go to Object library,Click Open,Select file type *.olb
Look for or search for
stndrd20.olb
2) Select Tools -> Object library
Select Component Tab.
Drag calender & drop it on an object group select copy
3) Select Attached libraries -> Create
Look for or search for
Calender.pll
click open
Attach, Select No
4) Go to Program -> Compile All
On Error
Copy(To_chardate_lov.current_lov_date),date_lov.date_return_item);
Go_item(Date_lov.date_lov_retrun_item);
Close window and repeat same for the other errors.
5) Goto Canvas,Create and name it as First
6) Goto datablock Create manually.Go to Layout editor and place a text item.
7) For the text item write the following trigger
Trigger Name : key-listval
Trigger Text :
Date_lov.get_data(sysdate,':block3.text_item4',240,60,'Ok','Cancel',true,false,false);
8) Compile the form & Save
9) Execute the form
Hope this helps
I got the date lov button working.Thanks very much.it was easy.i have got one more problem.I have to execute the query when i select the particular date i.e search condition.
I have controls item like order date,order no,pseudo key,ship date.when i select the date,i should get the details related to order no,order date,pseduo key,ship date.please help me out in this matter.
thanks
Please help me
Regards,