This discussion is archived
1 2 Previous Next 16 Replies Latest reply: Dec 1, 2012 4:44 AM by O.Developer RSS

Date Filed

951926 Newbie
Currently Being Moderated
Dear All,

I have one 'Date' Data Type Filed,

I need to show this date at run run time.

I am using

Message('The Date is '||To_Date(:hr.trdate,'dd/mm/yyyy'));

But its throw the following error.

FRM-40735

How to Solve the issue.

Please give me one solution

Thanks and Regards,
Fazil
  • 1. Re: Date Filed
    Nicolas.Gasparotto Oracle ACE
    Currently Being Moderated
    Not sure which Oracle product your question is about, but certainly should not be reported into this forum. It is all about Feedback Forums and Suggestions !

    +-- thread locked --+

    Nicolas.
  • 2. Re: Date Filed
    BluShadow Guru Moderator
    Currently Being Moderated
    Question now moved to Oracle Discussion Forums » Application Development in PL/SQL » Forms
    and thread unlocked.
  • 3. Re: Date Filed
    Prabodh Guru
    Currently Being Moderated
    Fazil,
    I have one 'Date' Data Type Filed,
    I need to show this date at run run time.

    I am using

    Message('The Date is '||To_Date(:hr.trdate,'dd/mm/yyyy'));

    But its throw the following error.

    FRM-40735

    How to Solve the issue.

    Please give me one solution>

    Please post the complete message that comes after FRM-40735.

    Forms Version?
    The Message is in which trigger?

    Cheers,
  • 4. Re: Date Filed
    MLBrown Journeyer
    Currently Being Moderated
    Prabodh is right, in order to know what the "real problem" is we need to know the error that comes after the FRM-40735.

    I'm just guessing, but if the :hr.trdate is already defined as a date field, then that is probably your problem. If you try to do a TO_DATE on a date field, Oracle will honk. If it is a date field, then try TO_CHAR instead:
    Message('The Date is '||TO_CHAR(:hr.trdate,'dd/mm/yyyy'));
  • 5. Re: Date Filed
    951926 Newbie
    Currently Being Moderated
    Dear All,

    I am using Oracle Forms 10g Oracle Database 10g and window xp Profession Operating System .

    I need to check the date filed is in given range

    for example

    If to_date(:hr.trdate,'dd/mm/yyyy') not between '01/01/2003' and '31/12/2099' Then
    Message('Tr date is not in give Range');
    Raise Form_Trigger_Failure;
    End;

    when I applying the 'when validate item trigger' of :hr.trdate.then i will got the error is FRM-40735.

    How to solve this issue.

    Please give me one solution

    Thanks and Regards,
    Fazil
  • 6. Re: Date Filed
    HamidHelal Guru
    Currently Being Moderated
    As salamualikum, Fazil


    >
    If to_date(:hr.trdate,'dd/mm/yyyy') not between '01/01/2003' and '31/12/2099' Then
    try this
    If to_date(to_char(:hr.trdate,'dd/mm/yyyy'),'dd/mm/yyyy') not between '01/01/2003' and '31/12/2099' Then
    Hope this helps

    If someone response is correct or helpful mark it.
  • 7. Re: Date Filed
    951926 Newbie
    Currently Being Moderated
    Dear All,

    I Applied the following code.

    If to_date(to_char(:hr.trdate,'dd/mm/yyyy'),'dd/mm/yyyy') not between '01/01/2003' and '31/12/2099' Then

    Again I got the error FRM-40735

    Please help me.

    Thanks and Regards,
    Fazil
  • 8. Re: Date Filed
    HamidHelal Guru
    Currently Being Moderated
    Dear Fazil
    I Applied the following code.

    If to_date(to_char(:hr.trdate,'dd/mm/yyyy'),'dd/mm/yyyy') not between '01/01/2003' and '31/12/2099' Then
    then can try this
     If  to_char(:hr.trdate,'dd/mm/yyyy') not between to_char('01/01/2003','dd/mm/yyyy') and to_char('31/12/2099','dd/mm/yyyy') Then
    Again I got the error FRM-40735
    may be error says more then write. Please write the whole error message.

    Thanks,
    Hamid

    If someone response is helpful or correct, mark it.
  • 9. Re: Date Filed
    951926 Newbie
    Currently Being Moderated
    Dear All,

    I used the following code,
    If to_char(:hr.trdate,'dd/mm/yyyy') not between to_char('01/01/2003','dd/mm/yyyy') and to_char('31/12/2099','dd/mm/yyyy') Then

    Again I got the frm- 40735

    I catched the error in ON-ERROR(Form Level Trigger)
    Message('Error_Code is '||Error_Code);
    Pause;

    Then I got the Error_Code is 40735

    Please help me .

    Thanks and Regards,
    Fazil
  • 10. Re: Date Filed
    O.Developer Journeyer
    Currently Being Moderated
    THe Correct Message usage for this is...


    Ex ..EMP.HIredate


    mESSAGE(TO_CHAR(:emp.hIREDATE,'dd-mon-yyyy'));

    IF you got any error, let me know
  • 11. Re: Date Filed
    951926 Newbie
    Currently Being Moderated
    Hi,

    This work successfully
    mESSAGE(TO_CHAR(:emp.hIREDATE,'dd-mon-yyyy'));

    I didn't get any error message;

    Thanks and Regards,
    Fazil
  • 12. Re: Date Filed
    951926 Newbie
    Currently Being Moderated
    Dear All,

    I used the following code,
    If to_char(:hr.trdate,'dd/mm/yyyy') not between to_char('01/01/2003','dd/mm/yyyy') and to_char('31/12/2099','dd/mm/yyyy') Then

    Again I got the frm- 40735

    I catched the error in ON-ERROR(Form Level Trigger)
    Message('Error_Code is '||Error_Code);
    Pause;

    Then I got the Error_Code is 40735

    Please help me .

    Thanks and Regards,
    Fazil
  • 13. Re: Date Filed
    O.Developer Journeyer
    Currently Being Moderated
    Hi

    Firstly,,, if you get what you need, then close the thread accordingly.

    Secondly, for your second question, please past here your exact sample code- to get correct help
  • 14. Re: Date Filed
    951926 Newbie
    Currently Being Moderated
    Dear All,

    I used the following codes

    1.
    IF TO_DATE (TO_CHAR (:HR.TRDATE, 'dd/mm/yyyy'), 'dd/mm/yyyy') NOT BETWEEN '01/01/2003' AND '31/12/2099' THEN
    Message('Tr Date is not between 01/01/2003' AND 31/12/2099');
    RAISE FORM_TRIGGER_FAILURE;
    END IF;
    2.
    IF TO_DATE (:HR.TRDATE, 'dd/mm/yyyy') NOT BETWEEN '01/01/2003' AND '31/12/2099' THEN
    Message('Tr Date is not between 01/01/2003' AND 31/12/2099');
    Raise Forms_Trigger_Failure;
    END IF;


    when I use the mention code,then i will get the error frm- 40735

    Please give me one solution for the mentioned issue.

    Thanks and Regards,
    Fazil
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points