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.

FeedbackOpens in a new tab