OraFAQ Forum: Forms » VALIDATATION

Home » Developer & Programmer » Forms » VALIDATATION (Oracle form10g database 10g)

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

VALIDATATION [message #613586]

Thu, 08 May 2014 05:44

zeeshan_mhd
Messages: 9
Registered: September 2008
Location: india

Junior Member

My Form one field out put is

SHIFT
A
A
B
B
C

I want validation like when i do update/change any things from this above said it should be a single character and that should be either 'A' OR 'B' 'C' and should be uppercase any help please

Report message to a moderator

Re: VALIDATATION [message #613588 is a reply to message #613586]

Thu, 08 May 2014 05:55

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

Senior Member
Account Moderator

In item's Property Palette:
- set item's MAX length to 1
- set case to UPPERCASE

Create WHEN-VALIDATE-ITEM trigger which would check whether item's value is one of A, B or C; if not, raise an exception.

Report message to a moderator

Re: VALIDATATION [message #613590 is a reply to message #613588]

Thu, 08 May 2014 06:32

zeeshan_mhd
Messages: 9
Registered: September 2008
Location: india

Junior Member

trigger would be post_change or validate_item ?

item value already showing on screen i would like to update .

Report message to a moderator

Re: VALIDATATION [message #613591 is a reply to message #613590]

Thu, 08 May 2014 06:48

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

Senior Member
Account Moderator

Avoid POST-CHANGE triggers; they relic of the past (Forms 3.0). In more recent versions, you should use WHEN-VALIDATE-... triggers whenever you want to validate something.

Report message to a moderator

Re: VALIDATATION [message #613653 is a reply to message #613591]

Fri, 09 May 2014 00:21

Maaher
Messages: 7065
Registered: December 2001

Senior Member

You could also use a list item, since you only have three possible static values.

MHE

Report message to a moderator

Previous Topic:	block based procedure update error
Next Topic:	Software lock

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 02 00:43:20 CDT 2024