1 2 Previous Next 24 Replies Latest reply on Sep 27, 2016 8:39 AM by TSGal

    FMS 15 Bug with unstored calculation field

    MattMatthews

      Product and version: FMS15.0.1.137 and FileMaker Pro Adv 15.0.1.119

      OS and version: Win Server 2012

      Description: I just upgraded to FMS 15 from FMS 14 and found an issue with a report that uses an ustored calculation field.  When running this report from the sever hosted file the find query/script does not work.  If I download the same file and run it on straight from FM Pro Adv (no hosted by the Server) then the query/script works correctly as always and before with FMS14.  I tested with the field being a 'stored' value an it works on FMS15 however I need this to be unstored to capture the latest status.

       

      The calculation field uses Execute SQL as well to find the value.  Again this worked on FMS14 and still works on a non hosted files but not when hosted with FMS15.  This is the SQL:

      ExecuteSQL ( "select a.stage

      from ProcessTracking a, Stages b

      where a.stage = b.stage

      and a.QBInvoice=?

      and b.sort =

         (select Max(b2.sort) from ProcessTracking a2, Stages b2 where b2.stage = a2.stage and a2.QBInvoice=?)" ; "" ; ""  ; QBInvoice; QBInvoice )

       

      Workaround (if any): None really because if I make this a stored value but then the status 'stage' will not be updated.

       

      Please let me know if anyone has seen this issue, has a fix or workaround?

        1 2 Previous Next