0 Replies Latest reply on Apr 1, 2011 7:12 AM by powella

    Trying to search fields containing underscores with strings containing underscore yield unexpected...

    powella

      Summary

      Trying to search fields containing underscores with strings containing underscore yield unexpected results

      Product

      FileMaker Pro

      Version

      11.0v3

      Operating system version

      Windows 7, 32bit

      Description of the issue

      detailed in post:
      http://forums.filemaker.com/posts/73669f3122
      Basically FileMaker is treating a word containing an underscore as if that word were a quoted string with spaces instead of underscore when searching for greater than or less than values:

      3_4 would be treated as "3 4"

      Steps to reproduce the problem

      Make a table with some values as such:
      Na_Pa
      Nb_Lit
      Pa_Na

      Try searching
      >Na_Pa

      Expected result

      For the first search I would expect
      Nb_Lit
      Pa_Na

      and an empty set for the second search

      Actual result

      either search returns a full set
      Na_Pa
      Nb_Lit
      Pa_Na

      Exact text of any error message(s) that appear

      n/a

      Configuration information

      n/a