OraFAQ Forum: Forms » verification of a date

Home » Developer & Programmer » Forms » verification of a date (oracle forms 10g ,win xp pack 2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

verification of a date [message #580027]

Tue, 19 March 2013 08:35

goldray
Messages: 108
Registered: December 2012

Senior Member

I have 3 types list items:
1) :1 Day -> 31
2) Month: 1 -> 12
3) Year :1990 -> 2013

I want to check that the user has selected a valid date .. if not an error message will be displayed, for example:
31-02-2013: will be rejected

Any suggestions?

Report message to a moderator

Re: verification of a date [message #580030 is a reply to message #580027]

Tue, 19 March 2013 08:50

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Try to convert the given data to a date, if it is a wrong one Oracle will send an error:
TO_DATE(<your data>,'DD-MM-YYYY')

Regards
Michel

Report message to a moderator

Re: verification of a date [message #580031 is a reply to message #580030]

Tue, 19 March 2013 08:57

cookiemonster
Messages: 13972
Registered: September 2008
Location: Rainy Manchester

Senior Member

Use a proper calender instead.

Report message to a moderator

Re: verification of a date [message #580033 is a reply to message #580027]

Tue, 19 March 2013 09:08

goldray
Messages: 108
Registered: December 2012

Senior Member

I do the test in when-validate-record trigger?

Report message to a moderator

Re: verification of a date [message #580039 is a reply to message #580033]

Tue, 19 March 2013 11:59

cookiemonster
Messages: 13972
Registered: September 2008
Location: Rainy Manchester

Senior Member

yes, but really, use a proper calender, your users will much prefer it.

Report message to a moderator

Re: verification of a date [message #580055 is a reply to message #580039]

Tue, 19 March 2013 13:27

goldray
Messages: 108
Registered: December 2012

Senior Member

Ok Sir ,i will use calender

Report message to a moderator

Re: verification of a date [message #580058 is a reply to message #580055]

Tue, 19 March 2013 14:26

goldray
Messages: 108
Registered: December 2012

Senior Member

I am creating the calendar
I met a problem at creation 5th item (javabean):
I encountered this error:
frm-13008 cannot find javabean with name
oracle.forms.fd.JCalendar not found

[Updated on: Tue, 19 March 2013 14:27]

Report message to a moderator