1 2 Previous Next 16 Replies Latest reply: Dec 1, 2012 8:37 AM by Andreas Weiden RSS

    Date Filed

    951926
      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
          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
            Question now moved to Oracle Discussion Forums » Application Development in PL/SQL » Forms
            and thread unlocked.
            • 3. Re: Date Filed
              Prabodh
              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
                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
                  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
                    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
                      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
                        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
                          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
                            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
                              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
                                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
                                  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
                                    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