I am editing a very old solution, that originated in FMP 6, and is now running in FMP 16. A set field script step has the following calculation:
${Payment Splits [D]}::KEY Invoice Num
What is the meaning of the dollar sign syntax?
I am editing a very old solution, that originated in FMP 6, and is now running in FMP 16. A set field script step has the following calculation:
${Payment Splits [D]}::KEY Invoice Num
What is the meaning of the dollar sign syntax?
It means you named your table something that is not safe, so FM will alias it and reference it with a variable so as not to break references. In your case, you used square brackets.
If I rename these relations to make them compliant with FMP 16, will it break the scripts such as these? Where can I find this notation in the Help documentation?
Welcome, A2analytics ! Try this help topic:
Beverly
p.s. same in FMPro 16 help:
https://fmhelp.filemaker.com/help/16/fmp/en/FMP_Help/reserved-word-symbol-for-field-or-table.html
It means you named your table something that is not safe, so FM will alias it and reference it with a variable so as not to break references. In your case, you used square brackets.