Re: vexing MySQL query problem

delimit text with sql quotes, or single quotes perhaps? Also, I think it is better (and easier to debug) to build your sql query as a single string, then execute it. I wouldn't use DO for this. No point. Why is this way better? Because in the debugger you can view and even copy the completed SQL

Re: vexing MySQL query problem

Hi Sieg, What error are you getting? The problem may be that "text" is not only an LC keyword, it's also an SQL keyword. I find it's useful to always include table and column names in double quotes in SQL commands. Pete lcSQL Software On Fri, Jan 25, 2013 at 1:20 PM, Sie

Re: vexing MySQL query problem

Try: On 26/01/2013, at 8:20 AM, Sieg Lindstrom wrote: > do "revExecuteSQL myDB," & quote & "INSERT INTO RelevantTable (`Text`) " & > "VALUES ('" & thisText & "')" & quote -- Monte Goulding M E R Goulding - software development services mergExt - There's an external for that! ___

vexing MySQL query problem

I am working on an app to update a MySQL database table. Unfortunately, one of the fields in the table is named "Text" and I can't change that because it's a long-extant table which other non-LC scripts query. I am able to update the table except when the "Text" field is part of the query. Henc