Skip to main content

Creating and Initializing a Result Set

Creating and Initializing a Result Set

To create and initialize an SQL result set:

  1. Within an SQL adapter (either EnsLib.SQL.InboundAdapterOpens in a new tab or EnsLib.SQL.OutboundAdapterOpens in a new tab), connect to a DSN.

  2. Use the ExecuteQuery() or the ExecuteQueryParmArray() method of the adapter. You will receive, by reference, an instance of EnsLib.SQL.GatewayResultSetOpens in a new tab.

Note:

If you just use the %New() class method, you can create a result set, but it will not be initialized and cannot contain any data. To initialize the result set, use the procedure described here.

Purpose of this instance: Draft documentation
DocReleaseID: IRIS2025.1
Content loaded from:
/staging/learning/iris-doc/2025.1.x/doc/cache/en-us/src/
/staging/learning/iris-doc/2025.1.x/doc/ensemble/en-us/src/
/staging/learning/iris-doc/2025.1.x/doc/security/en-us/src/
/staging/learning/iris-doc/2025.1.x/doc/iris/en-us/src/
Excluded items: EAST, EDICOM, EHL72, EHL7T, HXHCINST, HXHCRN, HXIHINST, HXIHRN, PAGE_healthcare
FeedbackOpens in a new tab