CALENDAR [message #379064] |
Sun, 04 January 2009 05:55 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
hany_marawan
Messages: 198 Registered: April 2005 Location: Cairo - Egypt
|
Senior Member |
|
|
Hello
I read in pdf that I can appear CALENDAR by command "CALENDAR.SHOW".
I did this command in KEY-LISTVAL trigger but it's not working.
How can this working
Thanks
|
|
|
Re: CALENDAR [message #382174 is a reply to message #379064] |
Wed, 21 January 2009 04:18 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
parag_narkhede
Messages: 110 Registered: January 2008 Location: Pune
|
Senior Member |
|
|
While creating calendar on any date field, use following:
Steps:
a) Use Property Class TEXT_ITEM_DATE
b) To show calendar also set following:
List of Values to ENABLE_LIST_LAMP and Validate from List to 'No'
c) Add a KEY-LISTVAL trigger (calendar.show) that shows the Calendar with execution Hierarchy set to Override and
should not fire in query mode
d) Write this code in Key-Listval trigger calendar.show
e) To default to the current date as $$DBDATE$$
|
|
|
Re: CALENDAR [message #382418 is a reply to message #379064] |
Thu, 22 January 2009 04:00 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
hany_marawan
Messages: 198 Registered: April 2005 Location: Cairo - Egypt
|
Senior Member |
|
|
Hello,
First, thanks for attention
Second, I did all these steps but I found that this item disappeared from the form run?
can you conclude why this happened.
Thanks
|
|
|
Re: CALENDAR [message #382419 is a reply to message #379064] |
Thu, 22 January 2009 04:08 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
parag_narkhede
Messages: 110 Registered: January 2008 Location: Pune
|
Senior Member |
|
|
I hope you are working on Oracle Apps.
The reason for the item not getting appeared on the form at runtime, is because you might not have given TEXT_ITEM_DATE property class to that item.
I guess you have put the form in AU_TOP and compiling there and then moving .fmx to custom_top.
|
|
|
Re: CALENDAR [message #382452 is a reply to message #379064] |
Thu, 22 January 2009 06:36 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
hany_marawan
Messages: 198 Registered: April 2005 Location: Cairo - Egypt
|
Senior Member |
|
|
Hello,
Thanks again for attention.
I'm very happy for your comments,
but I want to tell you that I build complete and integraed modules like payroll and time and labor for my company, so I know how to build,compile and run the forms not one form.
So if you built the calenadr before, please send me your form with only this item not more - If you realy built this form not just give your recommendations -.
Thanks
|
|
|
|
|
Re: CALENDAR [message #384131 is a reply to message #379064] |
Mon, 02 February 2009 04:41 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
parag_narkhede
Messages: 110 Registered: January 2008 Location: Pune
|
Senior Member |
|
|
I assume following things: Please tell me if any of following is not happening with you:
1. You are working on Oracle apps?
2. while opening the form in form builder you haven't got any error?
3. or if you are developing form , you have started development from TEMPLATE.fmb from au_top.
4. if possible attach a scree shot of your form where that date field is not appearing.
My guess is there is something wrong in my understanding.
|
|
|
|
Re: CALENDAR [message #384602 is a reply to message #379064] |
Wed, 04 February 2009 07:07 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
parag_narkhede
Messages: 110 Registered: January 2008 Location: Pune
|
Senior Member |
|
|
OK. I think during compilation, it is not getting some libraries.
I know you have worked on forms before as well, But still Answer following questions..
are you putting the fmb in AU_TOP and the compile it?
1. You are working on Oracle apps?
2. while opening the form in form builder you haven't got any error?
3. or if you are developing form , you have started development from TEMPLATE.fmb from au_top.
4. if possible attach a scree shot of your form where that date field is not appearing.
|
|
|