FQL UPDATE

[Joshua]

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)

[Wim Decorte]

ExecuteSQL() only supports SELECT

[eos]

ExecuteSQL() only supports SELECT

There are plug-ins that support other statements, e.g. the (free) BaseElements or MBS.

[Joshua]

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)?

[Wim Decorte]

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

[Joshua]

Ohhhh. Ok, thank you for the info.