SQLResultSetPosition

SQLResultSetPosition[rs]
returns an integer that specifies the current position in a result set.
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]:=
Click for copyable input
Open a result set:
In[3]:=
Click for copyable input
The initial position is always 0:
In[4]:=
Click for copyable input
Out[4]=
In[5]:=
Click for copyable input
In[6]:=
Click for copyable input
Out[6]=
In[7]:=
Click for copyable input
In[8]:=
Click for copyable input
Out[8]=
Close the connection:
In[9]:=
Click for copyable input
In[10]:=
Click for copyable input
© 2008 Wolfram Research, Inc. japanese.gif