AnsweredAssumed Answered

Validation error when using "Always" validate…

Question asked by andrewggrant on May 5, 2011
Latest reply on May 10, 2011 by philmodjunk

Summary

Validation error when using "Always" validate…

Product

FileMaker Pro

Version

11 v3

Operating system version

OS X 10.6.7

Description of the issue

When a field is set to a Number and the validation is set to "Always", I receive an error 502 when attempting to set the field via a script with a variable using:

Set variable [$Number ; value: "5" ]
Set Field [Table::NumberField ; $Number ]

So I attempted to force the value to be a number with:

Set variable [$Number ; value: "5" ]
Set Field [Table::NumberField ; GetAsNumber ( $Number ) ]

and still received an error # 502 indicating validation issues.

If I changed the field validation to "Only during data entry" then everything works without any errors.

Steps to reproduce the problem

Create a new DB.
Create a single field (Table::NumberField) with the data type of Number.
Set validation to "Always"
Set Strict Data type to "Number"
Create a new record.
Run script of:
Set variable [$Number ; value: "5" ]
Set Field [Table::NumberField ; GetAsNumber ( $Number ) ]

Watch the Debugger window and see the error 502 appear on the second step of the script.

Expected result

Expected the Function, "GetAsNumber ( )" to actually convert the text "5" in the variable to a number value and allow it to be placed into the field.

Actual result

Nothing was entered into the field.
Debugger showed an error number 502.

Exact text of any error message(s) that appear

502.
Number value does not meet validation entry options

Configuration information

None.

Workaround

Turn off validation for "Always" and apply "Only during data entry".

Outcomes