AnsweredAssumed Answered

PHP Edit command fails if "Not Empty" validation set

Question asked by DanielKaan on Jan 7, 2014
Latest reply on Nov 20, 2014 by TSGal

Summary

PHP Edit command fails if "Not Empty" validation set

Product

FileMaker Server

Version

14.0.1.224

Operating system version

Mac OS X 10.8.5

Description of the issue

When using either of the 2 methods of editing an existing record in PHP, if there is any field on the layout referenced by the edit that has the validation "Not Empty" set, the edit fails without reporting any error message.

This is regardless whether the field in the field in question has data or not, whether it is that field that is being edited or not, or whether the "Always" or "Allow user to override during data entry" Validation flags are set.

Also, whether or not the field is being edited is irrelevant. That is the edit command may be modifying a totally different field and the edit still fails.

Steps to reproduce the problem

Set one or more fields on the layout referenced in a PHP edit command to have the validation "Not Empty" and then attempt to edit any record in that table using PHP.

Expected result

The record is appropriately edited by PHP regardless of the "Not Empty" Validation settings of fields on the PHP Edit layout (unless the validation genuinely fails).

Actual result

Interestingly "FileMaker::IsError($result)" does capture that an error occurred, but the "$result->getMessage()" is uninformatively blank.

Exact text of any error message(s) that appear

none

Configuration information

The problem is at the server end.  All client device types and browsers reported the same issue.

Workaround

Turn off "Not empty" validation on all fields on the PHP edit layout OR remove fields with the "Not Empty" validation flag set from the layout.  Of course this means it is not possible edit such fields.

Screen_Shot_2014-01-08_at_1.12.37_PM.jpg

Outcomes