OraFAQ Forum: Forms » Validate Time on field

Home » Developer & Programmer » Forms » Validate Time on field (Forms 6i)

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

Validate Time on field [message #472562]

Sun, 22 August 2010 04:02

arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates

Senior Member

I have a varchar field and user will enter the time in that field as per the format HH:MI HOURS:MINUTES.Actually there is no control on this field and user is making mistakes like instead of HH:MI he is entering HH;MI and i need to avoid this.How i can implement this.

Report message to a moderator

Re: Validate Time on field [message #472564 is a reply to message #472562]

Sun, 22 August 2010 04:20

ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia

Senior Member

Quote:

user is making mistakes like instead of HH:MI he is entering HH;MI and i need to avoid this.

Please Try this.


If Substr(:T,3,1) Not in (':') Then 
    Message('Wrong Time Entered!');
    Message('Wrong Time Entered!');
    
    Go_Item('T');
    Else
    
     Next_Item;
End if;

Hope this'll help you.

Regards,

Irfan

Report message to a moderator

Previous Topic:	Oracle Forms Designer has encountered a problem and needs to close.
Next Topic:	view the report between two dates

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 06:28:54 CDT 2024