Oninit
Talk to an expert →

Informix Error -4360: An ON LAST ROW clause has already been specified within this report.

Cause and resolution

An ON LAST ROW clause has already been specified within this report.

Only one ON LAST ROW control block is permitted in a report. Find the other ON LAST ROW control blocks, and combine their statements into one block.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-4360 fires when a report has more than one ON LAST ROW control block — per the official guidance, only one is permitted.

  1. More than one ON LAST ROW control block in the same report, per the official guidance — the direct, only cause.
Solutions / Resolution
  1. Find the other ON LAST ROW control blocks, and combine their statements into one, per the official guidance.
Examples
Duplicate ON LAST ROW blocks
FORMAT
  ON LAST ROW
    PRINT "Total: ", grand_total
  ON LAST ROW
    PRINT "End of report"
  -- -4360: only one ON LAST ROW block is allowed
Corrected
FORMAT
  ON LAST ROW
    PRINT "Total: ", grand_total
    PRINT "End of report"
Diagnostic Checks
  1. Check the report for more than one ON LAST ROW control block, and combine them.
Related Errors / Related Topics
  • -4359 — "An ON EVERY ROW clause has already been specified within this report." The equivalent restriction applied to ON EVERY ROW instead of ON LAST ROW.

A report has more than one ON LAST ROW control block — combine them into one.