Well, it does not seem to be a problem with multiple fields but with fields
that are integers.
INSERT INTO journal (j_date,casenmbr,j_descr,j_rate,j_status) VALUES
(jdate,cnmbr,erec.ev_title,erec.ev_rate,jstatus);
Fails, but
INSERT INTO journal (j_date,j_descr,j_rate,j_status) VALUES
(jdate,erec.ev_title,erec.ev_rate,jstatus);
Succeeds. The difference is casenmbr, an integer. j_rate is a decimal value,
j_date is a date and the others are character fields.