DatabaseLink`
DatabaseLink`

SQLResultSetPosition

SQLResultSetPosition[rs]

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

Details and Options

  • To use SQLResultSetPosition, you first need to load DatabaseLink using Needs["DatabaseLink`"].

Examples

open allclose all

Basic Examples  (1)

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:

Open a result set:

The initial position is always 0:

Close the connection:

Possible Issues  (1)

There is no data at position 0:

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