Hi William Vasu

As a guide for you, I attached a sample app containing a process with a "Database Update" tool with working SQL to update table 'lookup' to table 'destination'.

The SQL I used (kinda similar to yours):

update app_fd_destination a, app_fd_lookup b
set a.c_field1 = b.c_field1
where b.id = '1'

On running the app, first add a record in menu 'Lookup Record'. Add the record with the default values. Then click on 'Run Process' menu, and submit the process. On completion of the process, the app will return you to the 'Destination (After SQL Update)' menu displaying the column Field1 updated with the words 'Hello World' from the first table (Lookup table).

Reminder: All Joget Workflow database table columns starts with 'c_' (except id and dateCreated, dateModified.

APP_29032644.jwa

Hi Andrew,

I my particular case what I am trying to do is UPDATE the value of a field/column value in a table with the value of another field/column in the same table by using a table alias. See my example.

This is what seems to error.

Thanks

Hi Andrew,

I got it. The issue was multiple UPDATE statements in one query. What worked was:

UPDATE app_fd_x2_ref_sum
SET c_client_amt = (CASE WHEN c_resource_type = 'Client' THEN c_request_amount
ELSE '0.00'
END),
c_love_inc_amt = (CASE WHEN c_resource_type = 'Love INC' THEN c_request_amount
ELSE '0.00'
END),
c_business_amt = (CASE WHEN c_resource_type = 'Business' THEN c_request_amount
ELSE '0.00'
END),
c_church_amt = (CASE WHEN c_resource_type = 'Church' THEN c_request_amount
ELSE '0.00'
end),
c_agency_amt = (CASE WHEN c_resource_type = 'Agency' THEN c_request_amount
ELSE '0.00'
END)
WHERE c_request_amount IS NOT NULL

Thanks, Bill

In the plugin, it will simply execute the SQL you wrote, so the error is very much between your SQL query and the SQL server that you are pointing to. You should check for MySQL error and solve it by rewriting your query.

One more thing to try. If you run the exact query that you have written directly in the SQL's client/console, you should be getting the same error too. Cheers