DatabaseLink`
DatabaseLink`

SQLResultSetShift

SQLResultSetShift[rs,num]

shifts the current position of a result set by num.

Details and Options

  • To use SQLResultSetShift, you first need to load DatabaseLink using Needs["DatabaseLink`"].
  • SQLResultSetShift returns True if there is data at the new position and False if there is no data.

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: