2 Replies Latest reply on Apr 28, 2010 5:55 PM by user2175

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

    arnoldkegebein

      Summary

      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( $name.author = "Arnold"; $name.author )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:-

        • 1. Re: FM11 'smart' Copy/Paste in Expression Editor can create faulty expressions
          TSGal

          AKegebein:

           

          Thank you for your post.

           

          I am able to replicate the problem.  This problem only occurs with FileMaker Pro 11 running under Mac OS X 10.5.8 (Leopard).  When I double-click "author" in  either Mac OS X 10.6.3 or Windows XP, the entire variable name (name.author) is selected.  When pasted, it pastes correctly.

           

          I have forwarded your detailed post (Thank you) to our Development and Software Quality Assurance (Testing) departments for review and confirmation.

           

          TSGal

          FileMaker, Inc.

          • 2. Re: FM11 'smart' Copy/Paste in Expression Editor can create faulty expressions
            user2175

            I can confirm this bug also affects field names in the expression editor.

             

            Create in an expression editor window (script step, define field, etc.) a calculation that involves a related field:

             

            tablename::fieldname

             

            Double-click on the fieldname part of the expression to select it, copy with command-c and paste with command-v.

             

            result:

             

            tablename:: fieldname

             

            Note the extra space before the field name.

             

            More curious is that pasting into a text editor does not insert the space and copying from a text editor and pasting in FileMaker also does not insert the space. Only both copying and pasting within the FileMaker expression editor adds the space.

             

            Tested on:

             

            Mac OS 10.6.3

            FMPA 11.0v1