1 Reply Latest reply on Sep 29, 2014 10:15 AM by TSGal

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

    Malcolm

      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