DatabaseLink`
DatabaseLink`

SQLResultSetCurrent

SQLResultSetCurrent[rs]

reads the current row from a result set.

Details and Options

  • To use SQLResultSetCurrent, you first need to load DatabaseLink using Needs["DatabaseLink`"].
  • The following option can be given:
  • "GetAsStrings" Falsereturn the results as strings

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:

Shift the current position to the first row:

Get the current row:

Close the result set:

Options  (1)

"GetAsStrings"  (1)

Possible Issues  (1)

There is nothing to read before the first row:

There is nothing to read after the last row: