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

    Variables in finds fail when they have no content

    Crispin

      Summary

      Variables in finds fail when they have no content

      Product

      FileMaker Pro

      Version

      11.02

      Operating system version

      both

      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.

      Crispin

      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

      Workaround

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

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

          Crispin:

          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.

          TSGal
          FileMaker, Inc.