AnsweredAssumed Answered

A field validated by a value list will always return 506 error from a CWP-XML edit command

Question asked by Malcolm on Sep 28, 2014
Latest reply on Sep 29, 2014 by TSGal

Summary

A field validated by a value list will always return 506 error from a CWP-XML edit command

Product

FileMaker Server

Version

FMS 13

Operating system version

Mac OS X 10.9, 10.8

Description of the issue

A field that has the Validate by Value List option is effectively locked and may not be edited by CWP-XML.

Steps to reproduce the problem

1. Host a database on Server
2. Make an account accessible to XML
3. Generate a URL which will pass an edit command to a record in the database
4. Pass the URL to the server to confirm that the field is able to be edited
5. Change the validation options on the field to validate by value list.
6. Generate a URL that will edit the field and ensure that the edit value is an item from the value list.
7. Pass the URL to the server

Expected result

Error code 0.
XML data (fmresultset) describing the modified record.

Actual result

Error code 506

Configuration information

The issue has also been seen on a database hosted on fms13.0.2.295 on Win7

Workaround

remove validation by value list

Outcomes