AnsweredAssumed Answered

Find Mode not validating Data Type…

Question asked by andrewggrant on Jun 1, 2011
Latest reply on Jun 9, 2011 by philmodjunk

Summary

Find Mode not validating Data Type…

Product

FileMaker Pro

Version

FMPA 11 v3

Operating system version

OS X 10.6.7

Description of the issue

When manually searching a number field with "5tc" a validation error appears.

The same search in a script step fails to result in an error code in the debugger window.

Field: "Quantity Onhand"
Settings: Indexed, Auto-enter: “0”, Always validate, Required value, Only allow values of type: “Numeric Only”

Script Steps:
Enter Find Mode [ ]
Set Field [ Spares::Quantity Onhand; "5tc" ]
Perform Find [ ]

The result is that all records with the value of "5" in the field are found with the script.

I am trying to trap errors with a much more complicated search, but wish to see when a validation error occurs in the search steps. Can this be done? Is this a bug?

Steps to reproduce the problem

Field: "Quantity Onhand"
Settings: Indexed, Auto-enter: “0”, Always validate, Required value, Only allow values of type: “Numeric Only”

Script Steps:
Enter Find Mode [ ]
Set Field [ Spares::Quantity Onhand; "5tc" ]
Perform Find [ ]

No error when script is run.

Expected result

Expected a validation error in the debugger window.

Actual result

Debugger error code of "0" during all steps. Actual records found containing only part of my search.

Exact text of any error message(s) that appear

None.

Workaround

Looking for a way to trap errors in validation that occur when manually performing same steps as the script performs.

Outcomes