Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Sally Woolrich — — source: Informix-list mailing list archive (1991-1998)
Remember that in later versions of Informix (we use 4.10 tools, 5.00
engine) none of the 'ON LAST ROW' stuff is executed if no rows are
found. We use the following type of stratagy in 4GL programs:
MAIN
...
LET rowsfound = FALSE
FOREACH cursor-name
OUTPUT TO REPORT myreport VALUES( 0, .... )
LET rowsfound = TRUE
END FOREACH
IF rowsfound = FALSE
OUTPUT TO REPORT myreport VALUES( 100, ... )
END IF
END MAIN
REPORT( p_status, ... )
DEFINE
p_status INTEGER,
...
FORMAT
....
ON LAST ROW
IF p_status = 0 THEN
PRINT 'end of report'
ELSE
PRINT header
PRINT 'No rows found'
END IF
END REPORT
--
============================================================================
Sally Woolrich | This mail contains my personal
sally@excelsis.demon.co.uk | views not those of my employer!
============================================================================
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.