INTERVIEW QUESTIONS ORACLE DETAILS

Question: How to get a calender in date field in oracle forms?

Answer: 1)Set the LOV of the item for which calendar to be attached as ENABLE_LIST_LAMP LOV, which is included in the TEMPLATE form.

2)Set ”Validate from List” to 'No' in the property palette of that item .

3)Then in KEY–LISTVAL trigger of that item write

calendar.show;

1)Set the LOV of the item for which calendar to be attached as ENABLE_LIST_LAMP LOV, which is included in the TEMPLATE form.

2)Set ”Validate from List” to 'No' in the property palette of that item .

3)Then in KEY–LISTVAL trigger of that item write

calendar.show;
Source: CoolInterview.com

--- To add a calendar in Form 6i
You will need to files
1) stndrd.olb
2) calendar.pll
******************
1) From within forms open the file stndrd.olb via file>> open.(Search for stndrd.olb file in your hard disk).This will add the item "standards" to the object navigator/object libraries section. This will now always appear in the object navigator.

2) Next open the form that you wish the calendar to be on.

3) Expand the "library tabs" section of the "standards" item in "object libraries" to reveal 5 items, inc. "components". Right click on "components" & select "object libraries" from the menu that appears.

4) From the box that appears select the component "calendar" and drag it to the form you wish it to be added to within the "object navigator". It will then ask whether you want to "sub-class" or "copy". Select copy, or the form with the calendar will not work on PC's that does not have the standards item added. Copying will add all required bits you need for the calendar.

5) Next open the "calendar.pll" file & this will add a "calendar" item to the "pl/sql libraries" section on the "object navigator". Select the "program unit" section and drag it up to the "programs unit" sectino of your form. This will add 2 items to the "programs unit" section (date_lov - package spec & date lov -package body).

6) Next on my form i added a button to call the calender with a "when_button_pressed" trigger & added this code.
********************************
DATE_LOV.GET_DATE
(NVL(:BLOCK.ITEM, SYSDATE),
'BLOCK.ITEM',
200, 100,
'SELECT DATE',
'OK','CANCEL',
TRUE, FALSE, FALSE);
********************************
The block.item is where you want the date to be inserted into via the calendar user interaction. Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

• There should not be any Spelling Mistakes.
• There should not be any Gramatical Errors.
• Answers must not contain any bad words.
• Answers should not be the repeat of same answer, already approved.
• Answer should be complete in itself.

Name :*
Email Id :*
Answer :*
Verification Code	Not readable? Load New Code
Enter the above shown code: *
	Inform me about updated answers to this question