Re: Forms 4.5 Handling columns number (3.1)

On a When-Validate-Item trigger attached to this item, if the value of this field is greater than 99.9, show an error message and raise a form trigger failure.

Joe Strano
Dulcian, Inc.

Darren Palmer wrote:

> Dear all,
>
> I have a numeric field which is defined as number(3.1)
>
> When the user enters the following values there is no problem
>
> 99.9
>
> How can I stop the user entering 999 on the form - the form allows
> it but the database does not because the value is larger than the
> precision for this column
>
> Thanks in advance
> Darren
Received on Fri Mar 27 1998 - 00:00:00 CET