Informix Error -4359: An ON EVERY ROW clause has already been specified within this report.
Cause and resolution
An ON EVERY ROW clause has already been specified within this report.
Only one ON EVERY ROW control block is permitted in a report. Find the other ON EVERY ROW control blocks, and combine their statements into one block.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-4359 fires when a report has more than one ON EVERY ROW control block — per the official
guidance, only one is permitted.
- More than one
ON EVERY ROWcontrol block in the same report, per the official guidance — the direct, only cause.
Solutions / Resolution
- Find the other
ON EVERY ROWcontrol blocks, and combine their statements into one, per the official guidance.
Examples
Duplicate ON EVERY ROW blocks
FORMAT
ON EVERY ROW
PRINT rec.order_id
ON EVERY ROW
PRINT rec.order_date
-- -4359: only one ON EVERY ROW block is allowed
Corrected
FORMAT
ON EVERY ROW
PRINT rec.order_id, rec.order_date
Diagnostic Checks
- Check the report for more than one
ON EVERY ROWcontrol block, and combine them.
Related Errors / Related Topics
- -4360 — "An ON LAST ROW clause has already been specified within this report." The
equivalent restriction applied to
ON LAST ROWinstead ofON EVERY ROW.
A report has more than one ON EVERY ROW control block — combine them into one.