Joshua Posted July 28, 2015 Share Posted July 28, 2015 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) Link to comment Share on other sites More sharing options...
Wim Decorte Posted July 28, 2015 Share Posted July 28, 2015 ExecuteSQL() only supports SELECT Link to comment Share on other sites More sharing options...
eos Posted July 28, 2015 Share Posted July 28, 2015 ExecuteSQL() only supports SELECT There are plug-ins that support other statements, e.g. the (free) BaseElements or MBS. Link to comment Share on other sites More sharing options...
Joshua Posted July 28, 2015 Author Share Posted July 28, 2015 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)? Link to comment Share on other sites More sharing options...
Wim Decorte Posted July 28, 2015 Share Posted July 28, 2015 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 Link to comment Share on other sites More sharing options...
Joshua Posted July 28, 2015 Author Share Posted July 28, 2015 Ohhhh. Ok, thank you for the info. 1 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 3187 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now