AnsweredAssumed Answered

FM11 'smart' Copy/Paste in Expression Editor can create faulty expressions

Question asked by arnoldkegebein on Apr 1, 2010
Latest reply on Apr 28, 2010 by user2175


FM11 'smart' Copy/Paste in Expression Editor can create faulty expressions

Description of the issue

FileMaker Product(s) involved:FileMaker Pro 11.0 (Adv)Operating System(s) involved:Mac 10.5.8Detailed description of the issue:In the Expression Editor FM11 uses a 'smart' Cut/Copy/Paste function as known from text processing programs: in certain situation it might add a space before or after the pasted text. This could create faulty expression.In many cases the expression checker will catch faulty expressions like broken field names (table:: field). But with local or global variables the checker cannot find a faulty expression. If the user relies on the expression checker he will assume the expression is correct.Exact steps to reproduce the issue:1.  Create/open a database2.  Open the Expression Editor, for example in the Data Viewer3.  Enter the expression: Let( $ = "Arnold"; $ )4.  Highlight the second "author" with a doubleclick on it5.  Cut selection and paste it again without changing the cursor position6.  Evaluate nowExpected Result:The user might expect the result "Arnold".Actual Result:An empty string.Exact text of any error message(s) that appeared:N/AAny workarounds that you have found:-