OraFAQ Forum: Forms » Date and Time Validation

Home » Developer & Programmer » Forms » Date and Time Validation (Forms 6i DB 9i)

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

Date and Time Validation [message #497752]

Mon, 07 March 2011 01:12

rahshar
Messages: 26
Registered: July 2006
Location: Oman

Junior Member

Dear All,

I have a Situation for Date and Time Validation.

I have 4 fields, d1,d2,t1,t2 all are date datatype
I have 1 field for R1 for resource a varchar datatype

1. d1 and d2 for date
2. t1 and t2 for time.

The User enter d1 and d2, t1 and t2
eg 01-03-2011 - > d1
01-03-2011 - > d2

9:00 - > t1
9:30 - > t2

and 'Room1' - R1 for resource.

any other entry having the same data, or have partial data should not be allowed.

like on 01-03-2011 between 9:29 to : 9:40
or even 8:30 to 9:01 on the same date or (replicated dates boundaries) should not be allowed.

How can we achieve this.

Any one has done this exercise.

Thanks in Advance

Report message to a moderator

Re: Date and Time Validation [message #497772 is a reply to message #497752]

Mon, 07 March 2011 02:10

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Why 4 items, when the same could be done with 2 of them?

WHEN-VALIDATE-ITEM trigger might be a choice. Logic is something you'll write by yourself (as you know what you want to allow, what not).

Report message to a moderator

Re: Date and Time Validation [message #497969 is a reply to message #497772]

Mon, 07 March 2011 23:44

mkhalil
Messages: 108
Registered: July 2006
Location: NWFP Peshawar Pakistan

Senior Member

I am also of the view as littlefoot. At form level change the data type property to datetime for entry and display purpose.

Report message to a moderator

Previous Topic:	problem when i run a form
Next Topic:	Post Query Trigger

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Sep 17 05:00:10 CDT 2024