Re: Forms 3: query with non-numeric in number fields

idixon_at_syntaxis.ukmail.net (Ian Dixon) writes:

> 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.

Sorry, what I meant to say was:

If a value such as '13%' is entered then I get the error. Without the test in the pre-query, forms will happily take this and do the query.

>
> 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 | |

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