Search found 2 matches

by hefreeman-gmail
Mon Nov 09, 2020 6:21 pm
Forum: Getting Started with LiveCode - Experienced Developers
Topic: Problems with UPDATE on a MySQL db
Replies: 1
Views: 888

Re: Problems with UPDATE on a MySQL db SOLVED!

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...
by hefreeman-gmail
Mon Nov 09, 2020 6:10 pm
Forum: Getting Started with LiveCode - Experienced Developers
Topic: Problems with UPDATE on a MySQL db
Replies: 1
Views: 888

Problems with UPDATE on a MySQL db

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" ...

Go to advanced search