mleering

ExecuteSQL (SELECT GlobalField FROM Table When Table = Empty)

Discussion created by mleering on Jun 13, 2017
Latest reply on Jun 14, 2017 by user19752

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.

Outcomes