DatabaseLink`
DatabaseLink`

SQLResultSetShift

SQLResultSetShift[rs,num]

shifts the current position of a result set by num.

Details

Examples

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 0:

Shift two rows:

The new position is 2:

Shift two rows again:

Now the position is 4:

Close the result set: