7 Replies Latest reply on Jun 25, 2012 10:58 PM by alex_zueiv

REAL Bug: Adding [:] in a table name, brakes MERGE FIELD relationship

inicksf Apr 25, 2009 6:05 PM

Summary

Description of the issue

Adding ':' in the table name is not prohibited by any Filemaker warning...Doing so, all seems to work fine, except MERGE FIELD: Inserting merged field in a layout as: , continue to show instead of the field's data ... After to have burnt my brain per hours, and pray all Gods known, I have fixed this trouble.Why I know this is a real bug?I have added ':' in some of table names of my Database, thinking to present its better later in my development.Then, all merged fields I have put in my layouts before the add of the [:] was working well, only new merged fields added AFTER the add didn't work...Worth ! Just the edition of a merged field by double-click on it, then validate it, was enough to "brake" it and show the even in "browse" mode... DO NOT PUT ':' IN TABLE NAME

1. Re: REAL Bug: Adding [:] in a table name, brakes MERGE FIELD relationship

TSGal Apr 27, 2009 2:19 PM (in response to inicksf)

inick06:

Thank you for your post.

Our Development and Software Quality Assurance (Testing) department are aware of this issue, but no additional information is available at this time. Until this is changed, remove any colons from table names.

TSGal
FileMaker, Inc.
Like Show 0 Likes(0)

Actions
2. Re: REAL Bug: Adding [:] in a table name, brakes MERGE FIELD relationship

mw_1 Feb 20, 2010 9:13 AM (in response to inicksf)

Almost a year on and this is an issue still - I'm using FMP Advanced 10.0v3.

I tried to use a field from a relationship in a merge field and the "::" gets expanded to the current time when I access a field from a relationship with a ":" in its name.

This works fine:
Project <<UI::g.ProjectName>>

This fails:
Project <<UI:Meetings::ProjectName>> gets displayed as Project <<UI:Meetings17:05:23ProjectName>>
Like Show 0 Likes(0)

Actions
3. Re: REAL Bug: Adding [:] in a table name, brakes MERGE FIELD relationship

TSGal Feb 22, 2010 12:40 PM (in response to inicksf)

mw:

No additional information is available at this time. A colon in a merge field will still not work as expected.

TSGal
FileMaker, Inc.
Like Show 0 Likes(0)

Actions
4. Re: REAL Bug: Adding [:] in a table name, brakes MERGE FIELD relationship

mw_1 Mar 4, 2010 6:58 AM (in response to inicksf)

Thanks TSGal - can you please confirm which characters I'm allowed to use in a table name without breaking the merge field functioanlity?

Cheers
Michael
Like Show 0 Likes(0)

Actions
5. Re: REAL Bug: Adding [:] in a table name, brakes MERGE FIELD relationship

TSGal Mar 4, 2010 8:23 AM (in response to inicksf)

mw:

I only see colons in the table occurrence name causing a problem. That doesn't mean other characters will cause a problem, but the colon is the only character reported that causes the problem. Sorry I can't be more definitive. If you find another character that makes this fail, please let me know.

TSGal

FileMaker, Inc.
Like Show 0 Likes(0)

Actions
6. Re: REAL Bug: Adding [:] in a table name, brakes MERGE FIELD relationship

philmodjunk Jun 25, 2012 3:51 PM (in response to inicksf)

This bug does not occur in FileMaker 12.
Like Show 0 Likes(0)

Actions
7. Re: REAL Bug: Adding [:] in a table name, brakes MERGE FIELD relationship

alex_zueiv Jun 25, 2012 10:58 PM (in response to inicksf)

Colon sign (:) in a table occurrence name also breaks functionality of the script step Set Field By Name []. In script debugger it returns error 102 (Field is missing). This issue exists in FMP 12v1 too.
Like Show 0 Likes(0)

Actions

Go to original post