You do not need a plugin to do SQL in FileMaker. ExecuteSQL works great too
For SELECT only. INSERT, UPDATE & DELETE do not work with ExecuteSQL() function.
Sent from miPhone
\"\" is used for fields that have space in their name so it was written correctly. Your code is also not working.
I managed to figure it out:
setvariable $sender value UTL::Sender;
setvariable $id value UTL::id;
BE_FileMakerSQL (Evaluate(Quote ("
SET \"sender\"='" &$sender & "'
You have to evaluate the variables beforehand in order to use their value. To do this you have to Quote the SQL code, append the value of the variable to the quote and then evaluate. The code is tested and working.
as a mention if the field is type text it is necessary to include the value in `` otherwise it is not working. Id is type number, you don't need `` for numbers.