2 Replies Latest reply on Jun 15, 2015 9:22 PM by Fred(CH)

    Portal sorting and ExecuteSQL ORDER BY are not consistent

      Summary

      Portal sorting and ExecuteSQL ORDER BY are not consistent

      Product

      FileMaker Pro

      Version

      14.0.1

      Operating system version

      Max OS X Yosemite

      Description of the issue

      Hello Forum,

      I just encountered what I think is a bug.  I have a portal of companies where I sort by the company name in ascending order.  The default name I give a company upon creation is (Untitled Company) -, followed by a timestamp.

      When this saves down, it shows up in the portal in the "U" section, so that I have, for example, in this order:

      Unrein Constructors, Inc.
      Unser Construction, Inc.
      (Untitled Company) - etc.


      In a script, for certain reasons, I execute the following SQL query using ExecuteSQL:

      ExecuteSQL ( "SELECT id, name FROM Company ORDER BY name ASC"; ""; "" )

      Now, ExecuteSQL properly returns the sort order as this:

      (Untitled Company) - etc.
      A ... T ...
      Unrein Constructors, Inc.
      Unser Construction, Inc.


      In other words, it floats to the top.

      I think this a bug.  It would seem that FM's indexing system is ignoring the "(", and it really shouldn't do that.

      Thoughts?

      Steps to reproduce the problem

      (See Description)

      Expected result

      (See Description)

      Actual result

      (See Description)

      Exact text of any error message(s) that appear

      None