Forms 3: query with non-numeric in number fields

I've got a form that needs to be sure that the user has entered something when in query mode. It does this by testing all the queryable fields in a PRE-QUERY trigger. If all are null, form_trigger_failure gets raised. Works fine for all the char fields.

The problem occurs with the one number field. When it is included in the test, I get the value_error exception and an FRM-50016 message.

I can avoid the value_error by putting the code in a block of its own and I can lose the message by setting system.message_level to 15. It works but is there a better way?

Any suggestions gratefully received.

Regards

Ian

Ian Dixon                      |  Email : idixon_at_syntaxis.ukmail.net    |
Independent Oracle Consultant  |  Tel   : +44 (0)734 478092             |
Reading, England               |                                        |