Order of access for OUTPUT ResultSet objects
- Last Updated: January 16, 2024
- 1 minute read
- OpenEdge
- Version 12.8
- Documentation
The stream of data in an OUTPUT ResultSet can
be thought of as a one-directional tape. It must be read in sequence,
and there is no way to get the same data more than once or go backwards.
When getting the data from a single TABLE or TABLE-HANDLE,
the data for each row and each field in that row must be requested
in sequence, and no request can be repeated. Also, if there is more
than one OUTPUT TABLE or TABLE-HANDLE parameter
for a method, they must be perused in sequence. Data from the first TABLE or TABLE-HANDLE parameter
must be completely fetched or the ResultSet closed
before any data can be retrieved from the second, and so on. It
is possible, however, to skip data. For example, you can fetch the
value of field 1 and then the value of field 10; however, you cannot
then reverse and obtain the values for fields 2 through 9.