AnsweredAssumed Answered

FMRESULTSET - Column Name unacceptable

Question asked by AlenHusanovic on Feb 25, 2011
Latest reply on Feb 27, 2011 by davidhead

Summary

FMRESULTSET - Column Name unacceptable

Product

FileMaker Server

Version

10

Operating system version

Windows Server 2008

Description of the issue

Hello,

I'm trying to edit record with FMRESULTSET but column with the dot(.) in it's name is giving me a lot of problems. Update to column name in the database is not an option.

I have following problem with the XML result set:

http://<>/fmi/xml/fmresultset.xml?-db=EXPORTER&-lay=NEW_CMP&-recid=2704&Rating.n=1&_Subcategory=Corporate+Pension&_Category=Investor&-edit

Like you can check from the previous example I want to update following columns: _Rating.n, _Subcategory and _Category.

The problem is related to the "Rating.n" column. If I remove this column from the query, it works, but all columns with DOT within their name, cannot be updated I got an error message.

Steps to reproduce the problem

http://<>/fmi/xml/fmresultset.xml?-db=EXPORTER&-lay=NEW_CMP&-recid=2704&Rating.n=1&_Subcategory=Corporate+Pension&_Category=Investor&-edit

Expected result

XML - with updated entity

Actual result

I get following error:







Outcomes