I have the following excerpt which doesn't work:
CASE 'SENT FOR PAYMENT'
SET VAR vstatus = 6
SET VAR vuser_id = 'ACCT'
UPDATE d_inbox SET inbox_state = .vstatus, user_id = .vuser_id,
routing_dt = .#DATE, update_user_id_06 = .vwhichuser +
WHERE invoice_id IN &vprocess
BREAK
I changed the command to 2 separate commands and it works:
CASE 'SENT FOR PAYMENT'
SET VAR vstatus = 6
SET VAR vuser_id = 'ACCT'
UPDATE d_inbox SET inbox_state = .vstatus, +
user_id = .vuser_id WHERE invoice_id = .vinvoiceid
UPDATE d_inbox SET routing_dt = .#DATE, +
update_user_id_06 = .vwhichuser WHERE invoice_id = .vinvoiceid
BREAK
I can't seem to find anything in the help files which shows more than two
fields being updated in a single command.
Am I missing something here?