Originally posted by rao
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,