WOLFRAM

Wolfram Language & System Documentation Center

SQLResultSetRead[rs]

shifts the current position and then reads a row from a result set.

SQLResultSetRead[rs,num]

reads num rows from a result set.

Details and Options
Details and Options Details and Options
Examples  
Basic Examples  
Options  
"GetAsStrings"  
Applications  
See Also
Tech Notes
Related Guides
DatabaseLink`
DatabaseLink`

SQLResultSetRead

SQLResultSetRead[rs]

shifts the current position and then reads a row from a result set.

SQLResultSetRead[rs,num]

reads num rows from a result set.

Details and Options

Examples

open all close all

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 a result set:

Wolfram Language code: rs = SQLResultSetOpen[SQLSelect[conn, "roysched"]];

Read the first row:

Wolfram Language code: SQLResultSetRead[rs]

Read the second and third rows:

Wolfram Language code: SQLResultSetRead[rs, 2]

Read the last four rows:

Wolfram Language code: SQLResultSetGoto[rs, Infinity];
Wolfram Language code: SQLResultSetRead[rs, -4]

Close the result set:

Wolfram Language code: SQLResultSetClose[rs]
Wolfram Language code: CloseSQLConnection[conn];

Options  (1)

"GetAsStrings"  (1)

Wolfram Language code: Needs["DatabaseLink`"]
Wolfram Language code: conn = OpenSQLConnection["publisher"];
Wolfram Language code: rs = SQLResultSetOpen[SQLSelect[conn, "roysched"]];
Wolfram Language code: SQLResultSetRead[rs, "GetAsStrings" -> True]//InputForm
Wolfram Language code: SQLResultSetClose[rs]
Wolfram Language code: CloseSQLConnection[conn];

Applications  (1)

Wolfram Language code: Needs["DatabaseLink`"]

Process each row individually, and get the sum:

Wolfram Language code: conn = OpenSQLConnection["publisher"];
Wolfram Language code: rs = SQLResultSetOpen[SQLSelect[conn, "roysched", "royalty"]];
Wolfram Language code: res = 0;While[ListQ[data = SQLResultSetRead[rs]], res += data[[1]]]; res
Wolfram Language code: SQLResultSetClose[rs]
Wolfram Language code: CloseSQLConnection[conn];