The ExecToSet method

Use the ExecToSet method of the Query object for queries that return more than one row.

The ExecToSet method runs the query to completion and stores the results in the memory of the client program. If the result set is large, the memory of the client might be inadequate. The results returned by ExecToSet are accessible in arbitrary order.

Using ExecToSet, the connection is checked in after the call is completed. For details about checking connections in or out, see The ITConnection class.