Forms6i

[rao]

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

[skid]

Check out the calender supplied with Forms.

[santoshym]

Hi

You can use Attached libraries.The name of the file is

Calender.pll

Regards,

[rao]

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

[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

Regards,

[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


Regards,

[rao]

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,