0 Replies Latest reply on Nov 5, 2012 5:12 AM by ptinreston

    Errata — FileMaker Training Series 4 — Module 7 — Reports

    ptinreston

      Chapter 7.3

      Example 7.3.3

      Step 5

       

      The "DateOrdered" field references in the third (and fourth) line of the specified formula should be enclosed in escaped quotation marks, as is the _kf_CustomerID field reference. Not doing so yields a blank chart.

       

      More specifically...

       

      SQL = “Select Sum (Total) from ”Order” Where

      ”_kf_CustomerID” = ? and DateOrdered>= ? and DateOrdered<= ?”];

       

      should be

       

      SQL = “Select Sum (Total) from ”Order” Where

      ”_kf_CustomerID” = ? and "DateOrdered">= ? and "DateOrdered"<= ?”];

       

      I believe this is because the field reference in this case is part of an SQL query, rather than a field reference in a FileMaker calculation.

       

      I invite and welcome your comments.

       

      Phil Toll