Double check your quotes in the escaping as a first step. They appear to be curly quotes where the ones at the beginning of the statement are straight. It might just be a copy paste thing in Jive, but worth checking.
Thanks very much - I got it already ... double quotes indeed
Still, many thanks for the answer
I hope that you dont have a field named _Flag|x|REM
me, too co! but alas alack, even some long-time FMP developers make use of the "|" in all sorts of names.
The safest names (for tables, fields, scripts, layouts, value lists, etc.) follow these tips:
and my advice, because I work in all kinds of worlds, not just FMP:
use only alphanumerics and underscore (but not as first character). I might use spaces if I know it will be FMP only, but rarely!
@ coherentkris / @ beverly
Many thanks for the help and the slap on the wrist.
In my defence, shallow as it is, I have asked on numerous occasions to be allowed to rename the fields ... but never was allowed.
Thus we are provided a 'workaround' when using ExecuteSQL().
field => \"field\"
field|bad => \"field|bad\"