Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to prevent a user from entering characters into a number field

falconsMar 12 2002

How do you prevent a user from entering characters like A or B into a field that is defined as a numeric field?

Please note that
- we use block validation (for other reasons)
- we are not able to convert these numeric fields to character fields

We want to avoid a user being hasseled with the FRM-40209 ... message.
This message is
- not very helpfull because it does not inform us what the problem field is
- not suppressable

Any hints ?


Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 16 2002
Added on Mar 12 2002
4 comments
608 views