WOLFRAM

Wolfram Language & System Documentation Center

SQLResultSets[]

returns a list of the open SQLResultSet objects.

Details and Options
Details and Options Details and Options
Examples  
Basic Examples  
See Also
Tech Notes
DatabaseLink`
DatabaseLink`

SQLResultSets

SQLResultSets[]

returns a list of the open SQLResultSet objects.

Details and Options

Examples

Basic Examples  (1)

Wolfram Language code: Needs["DatabaseLink`"]

If you find that the examples in this section do not work as shown, you may need to install or restore the example database with the DatabaseLink`DatabaseExamples` package, as described in Using the Example Databases.

Open a connection:

Wolfram Language code: conn = OpenSQLConnection["publisher"];

Open two result sets:

Wolfram Language code: rs1 = SQLResultSetOpen[SQLSelect[conn, "roysched"]];
Wolfram Language code: rs2 = SQLResultSetOpen[SQLSelect[conn, "titleauthors"]];

List the open result sets:

Wolfram Language code: SQLResultSets[]

Close the result sets:

Wolfram Language code: SQLResultSetClose[rs1]
Wolfram Language code: SQLResultSetClose[rs2]
Wolfram Language code: CloseSQLConnection[conn];