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?

Reply via email to