Release 10.1A: OpenEdge Development:
Java Open Clients

> ## Order of access for output ResultSet objects

> 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.

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095