DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Forms6i

  1. #1
    Join Date
    Jan 2002
    Posts
    111

    Question

    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

  2. #2
    Join Date
    Apr 2002
    Location
    Philippines
    Posts
    77
    Check out the calender supplied with Forms.

  3. #3
    Join Date
    Mar 2001
    Posts
    635
    Hi

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

    Calender.pll

    Regards,
    Santosh

  4. #4
    Join Date
    Jan 2002
    Posts
    111
    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

  5. #5
    Join Date
    Mar 2001
    Posts
    635
    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,
    Santosh

  6. #6
    Join Date
    Jan 2002
    Posts
    111
    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,

  7. #7
    Join Date
    Jan 2002
    Posts
    111
    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,

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width