You need to quote the name:
ExecuteSQL ( "SELECT SUM(TTC) FROM FAC WHERE \"_idSIT\" = ? " ; "" ; ""; FAC::_idSIT) )
Or come up with a safer name convention as you say.....
1 of 1 people found this helpful
Damien is correct. This is an NOT acceptable naming practice to eSQL (FM) nor in the big-gun SQLs.
xaviervb, See my article/PDF/examples on eSQL. You'll find links to other examples and some great widgets (FM dbs) to help you write the eSQL:
p.s. also in Japanese: http://notonlyfilemaker.com/2014/01/missing-executesql/