WOLFRAM

Wolfram Language & System Documentation Center

SQLResultSetPosition[rs]

returns an integer that specifies the current position in a result set.

Details and Options
Details and Options Details and Options
Examples  
Basic Examples  
Possible Issues  
See Also
Tech Notes
Related Guides
DatabaseLink`
DatabaseLink`

SQLResultSetPosition

SQLResultSetPosition[rs]

returns an integer that specifies the current position in 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"]];

The initial position is always 0:

Wolfram Language code: SQLResultSetPosition[rs]
Wolfram Language code: SQLResultSetGoto[rs, 3];
Wolfram Language code: SQLResultSetPosition[rs]
Wolfram Language code: SQLResultSetShift[rs, 2];
Wolfram Language code: SQLResultSetPosition[rs]

Close the connection:

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

Possible Issues  (1)

Wolfram Language code: Needs["DatabaseLink`"]
Wolfram Language code: conn = OpenSQLConnection["publisher"];
Wolfram Language code: rs = SQLResultSetOpen[SQLSelect[conn, "roysched"]];

There is no data at position 0:

Wolfram Language code: SQLResultSetPosition[rs]
Wolfram Language code: SQLResultSetCurrent[rs]

There is no data at the end of the result set:

Wolfram Language code: SQLResultSetGoto[rs, Infinity]
Wolfram Language code: SQLResultSetPosition[rs]
Wolfram Language code: SQLResultSetCurrent[rs]
Wolfram Language code: SQLResultSetClose[rs]
Wolfram Language code: CloseSQLConnection[conn];