Have a very strange issue, we're building an application for browsing some of our FileMaker data in an external app, reading has worked fine but now that I am writing back changes, I've hit a bit of a wall.
Basic queries with "-edit" and a valid recid are succeeding, as long as no values are changed (i.e., if I edit and save without changes it works fine), but if any field is specified with a new value, I get back error 507. This is supposed to be a calculation/validation error, but we have both checked independently (myself and another developer at my company) and there is not validation on any of the fields we are trying to edit.
An example of the url syntax I am generating (dummy values for obvious reasons)
This one will work pefectly fine:
http://fm.myserver.com/fmi/xml/fmresultset.xml?-db=mydb.fp7&-lay=my_layout&-recid=1&-edit
this one would work, if fieldA in the specified record is already set to 1
http://fm.myserver.com/fmi/xml/fmresultset.xml?-db=mydb.fp7&-lay=my_layout&-recid=1&fieldA=1&-edit
And if fieldA is 1 as before, this will fail with error 507:
http://fm.myserver.com/fmi/xml/fmresultset.xml?-db=mydb.fp7&-lay=my_layout&-recid=1&fieldA=2&-edit
Any ideas on what might be causing this, or how to resolve it? The user account we're testing with has full read/write/create/delete access to all tables (we triple-checked), and as I said, there is no validation or calculations on any of the fields we are trying to write.
Thanks in advance for any insights...
