July 28, 201510 yr Hi guys, can anyone tell me what is wrong with my statement? I'm not getting any results and the variables are not empty. ExecuteSQL ("UPDATE CustomerDB SET CustComments = ? WHERE CustomerID = ?"; ""; ""; $CustEmailBody; $CustomerID)
July 28, 201510 yr ExecuteSQL() only supports SELECT There are plug-ins that support other statements, e.g. the (free) BaseElements or MBS.
July 28, 201510 yr Author Thank you for your response and thank you for the free plug-in. So from where or how is it that the UPDATE statement is meant to be used (https://fmhelp.filemaker.com/docs/13/en/fm13_sql_reference.pdf pg 19)?
July 28, 201510 yr That is for touching FM from the outside, using the xDBC interface. http://www.filemaker.com/help/13/fmp/en/html/func_ref3.33.6.html
Create an account or sign in to comment