DatabaseLink Paclet Symbol

SQLResultSetShift

SQLResultSetShift[rs, num]
shifts the current position of a result set by num.

MORE INFORMATION

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

CLOSE ALL

Basic Examples (1)

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 DatabaseExamples` package, as described in Using the Example Databases.

In[2]:=

Open a result set:

In[3]:=

Out[3]=

The initial position is 0:

The new position is 2:

In[6]:=

Out[6]=

Shift two rows again:

In[7]:=

Out[7]=

Now the position is 4:

In[8]:=

Out[8]=

Close the result set:

In[9]:=

In[10]:=