OK I got it figured out. Apparently it doesn't like field names like "FIRST" or "SECOND". Maybe it's in the documentation somewhere; if it isn't, then maybe it should.
Does putting the field name in brackets make a difference? such as [First]
In other systems, not filemaker, I seem to recall that was how to use a SQL keyword as a field name...