LiveCode Forums.

Just one comma, no error but no action!! Here's the last part of the statement: "additional1 = '" & tadditional1 & "'," && \ "WHERE indexcd = '" & tindexcd & "'" \ The comma before the 'WHERE' was messing up the code. I removed the comma, all is now well. Just posting it here made me look more caref...

Hi all, I'm having real issues with the UPDATE command on a MySQL database. I can connect to the db via a website and via a filemaker db via ODBC. The code I have for updating in livecode doesn't throw an error but nor does it update the database. Here's the code: answer gConnectionID put "cemdata" ...