OraFAQ Forum: Forms » Format for alphanumeric characters only

Home » Developer & Programmer » Forms » Format for alphanumeric characters only (Oracle Forms 9)

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

Format for alphanumeric characters only [message #336635]

Mon, 28 July 2008 08:32

kaydee08
Messages: 4
Registered: February 2007

Junior Member

Can anyone assist me with creating a format mask or some method to allow only alpha-numeric characters no (#,@,*) etc. to be entered into a field in Oracle Forms.

Report message to a moderator

Re: Format for alphanumeric characters only [message #336685 is a reply to message #336635]

Mon, 28 July 2008 12:29

kaydee08
Messages: 4
Registered: February 2007

Junior Member

Found something similar to this in one of forum posts, I placed this in WHEN-VALIDATE-TRIGGER of field after applying an
UPPER to vFieldVal. Returning a NULL value would indicate that only letters and\or numbers were found in field. Not sure if there is an alpha-numeric format that can be applied

SELECT LTRIM(RTRIM(vFieldVal, 'ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789'),'ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789')
INTO vDummy
FROM DUAL;

Report message to a moderator

Re: Format for alphanumeric characters only [message #339554 is a reply to message #336685]

Thu, 07 August 2008 18:06

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

Senior Member
Account Moderator

Also search this forum for 'iznumeric'.

David

Report message to a moderator

Previous Topic:	How to display from FND_LOBS
Next Topic:	Item Validation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 27 14:20:01 CDT 2024