Is there any way to use FileMaker's Internal SQL on a solution, where the names of the fields contain spaces?
SELECT Last Name from People WHERE Team Role = 'Judge'
SELECT zzID from People WHERE Last Name = 'Tan'
fails spectacularly - I think because the SELECT clause expects a comma delimited list of field names. Here, the field names in my solution use spaces (for legibility - and FM does not complain when I do that).
I have tried SELECT 'Last Name' but that only gives the literal in every row.
The FM ODBC/JDBC Guide is not much help. All it says on page 47 (Field Names) is
"The most common expression is a simple field name, such as calc or Sales_Data.Invoice_ID." (thanks!)
It should't make any difference, but I am using the BaseElement plugin 1.2.1 to send the query to FileMaker.
Any help would be gratefully appreciated. Thank you in advance.