OraFAQ Forum: Forms » form validations

Home » Developer & Programmer » Forms » form validations

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

form validations [message #143403]

Thu, 20 October 2005 05:59

cumars
Messages: 16
Registered: October 2005

Junior Member

hai friends,

i want to validate the text boxes in the oracle forms.

text box should accept only characters , if i enter numbers it should not accept. please help .

thanks in advance.

cumars

Report message to a moderator

Re: form validations [message #143407 is a reply to message #143403]

Thu, 20 October 2005 06:30

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Use a when-validate-item trigger.

compare the value with

replace(translate(the_value,'0123456789','0'),'0','')

If it is different, it means that the field is invalid. In that case you raise a form_trigger_failure (with an accompanying message)

MHE

Report message to a moderator

Re: form validations [message #143550 is a reply to message #143403]

Thu, 20 October 2005 18:05

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Is 'Data Type' = ALPHA usable for you?

David

Report message to a moderator

Previous Topic:	How to stop Records Saved dialog after COMMIT_FORM?
Next Topic:	Three new data block fields, not being queried from DB :(

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 03:47:32 CDT 2024