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.