1 2 Previous Next 17 Replies Latest reply on Jun 14, 2017 2:51 PM by user19752

    ExecuteSQL (SELECT GlobalField FROM Table When Table = Empty)

    mleering

      Chances are, the title of this thread says it all.

      There are various ways that I can access the contents of a global field within FileMaker, even when the table it resides in has zero records.

      I fear that this is not the case when I'm trying to access the contents of that global field via ExecuteSQL().

      Does anyone know of a way to achieve this?

       

      I've tried things like adding a LEFT JOIN to my SELECT statement to no avail.

        1 2 Previous Next