OraFAQ Forum: Forms » Only numbers are allowed

Home » Developer & Programmer » Forms » Only numbers are allowed (Forms [32 Bit] Version 6.0.8.12.1)

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

Only numbers are allowed [message #679683]

Mon, 16 March 2020 10:39

hercules27
Messages: 9
Registered: January 2013
Location: Athens

Junior Member

Hello,

I have a form with some criteria fields and a detail block (tabular) with results. (only query and search like an Lov )
I want one criteria field ( eg. phone_number) to accept only numbers and the characters _ and % (for wildcard searching)
That is, if a user inputs as a phone number 595A and clicks Find, he gets a message that only numbers are allowed.
But if he gives 28_59% to play. So only numbers and characters % and _ are allowed. How to inform the user that only numbers and characters % and _ are allowed?

By the way, when the user clicks Find, I have made a query procedure in the database like

FROM TELEPHONE_CATALOG T

WHERE TO_CHAR( T.PHONE_NO) LIKE '%'||P_PHONE_NO||'%'

Thank you.

Note:
This is actually a form that is used like a List of Values, when the user presses F9. Instead of making a record group with select statement, and an LOV ... and so on.
I call another form, which has some criteria and a tabular detail block with results. The detail block is based on a procedure, specifically a package with a query procedure. These are the standards that the company follows for all LOVS.

So although I may disagree, I must comply with these standards.

Report message to a moderator