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: 2627

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 ...
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: 2627

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