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 ...
Search found 2 matches
- 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
- 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 ...
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 ...