1 Reply Latest reply on Jul 27, 2010 10:38 AM by TSGal

    Variables in finds fail when they have no content



      Variables in finds fail when they have no content


      FileMaker Pro



      Operating system version


      Description of the issue

      Even with 11.02 if a variable is used in a find and the variable is empty FMP searches on the variable name rather than inserting nothing. With a result the find generally finds nothing. You can of course add a space but this is quirky and the sort of 'local knowledge' I thought I'd said goodbye to when I stopped using FMP6.

      We can program around it but I do hope this is sorted in the next bug release.

      I have attached a very simple demo.


      Steps to reproduce the problem

      create a script step with a stored find using a variable. This will find nothing. It should find all. Better still download the example I have posted in techtalk under the title 'Variables in finds (what 11.02 did not fix)'

      Expected result

      in the example the result should have found all records but instead the script finds nothing and stops showing the field as containing $Temp


      Check for nothing and substitute a space before using the variable if empty.

        • 1. Re: Variables in finds fail when they have no content


          Thank you for your post.

          I can verify the problem on both Mac OS X 10.5.8 and Windows XP.  The problem occurs with a Perform Find [Restore] script step where the variable is referenced.  However, this will work properly if you expand the Restore section as follows:

          Enter Find Mode []
          Set Field [ table::field ; $variable ]
          Set Field [ table::field2 ; <value> ]
          Perform Find []

          I have forwarded your post along with my findings to our Development and Software Quality Assurance (Testing) departments for review and confirmation.

          FileMaker, Inc.