DatabaseLink`
DatabaseLink`
SQLResultSetRead
SQLResultSetRead[rs]
shifts the current position and then reads a row from a result set.
SQLResultSetRead[rs,num]
reads num rows from a result set.
Details and Options
- To use SQLResultSetRead, you first need to load DatabaseLink using Needs["DatabaseLink`"].
- The following option can be given:
-
"GetAsStrings" False return the results as strings
Examples
open allclose allBasic Examples (1)Summary of the most common use cases
In[1]:=1
✖
https://wolfram.com/xid/0b9jl72ytb5t66gqhm-d1riej
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.
In[2]:=2
✖
https://wolfram.com/xid/0b9jl72ytb5t66gqhm-yf0
In[3]:=3
✖
https://wolfram.com/xid/0b9jl72ytb5t66gqhm-vqh
In[4]:=4
✖
https://wolfram.com/xid/0b9jl72ytb5t66gqhm-hrx
Out[4]=4
Read the second and third rows:
In[5]:=5
✖
https://wolfram.com/xid/0b9jl72ytb5t66gqhm-gm3
Out[5]=5
In[6]:=6
✖
https://wolfram.com/xid/0b9jl72ytb5t66gqhm-x1m
In[7]:=7
✖
https://wolfram.com/xid/0b9jl72ytb5t66gqhm-w4v
Out[7]=7
In[8]:=8
✖
https://wolfram.com/xid/0b9jl72ytb5t66gqhm-kax
In[9]:=9
✖
https://wolfram.com/xid/0b9jl72ytb5t66gqhm-l4p
Options (1)Common values & functionality for each option
"GetAsStrings" (1)
In[1]:=1
✖
https://wolfram.com/xid/0b9jl72ytb5t66gqhm-f9vkxw
In[2]:=2
✖
https://wolfram.com/xid/0b9jl72ytb5t66gqhm-yve
In[3]:=3
✖
https://wolfram.com/xid/0b9jl72ytb5t66gqhm-sj5
In[4]:=4
✖
https://wolfram.com/xid/0b9jl72ytb5t66gqhm-jfn
In[5]:=5
✖
https://wolfram.com/xid/0b9jl72ytb5t66gqhm-bls
In[6]:=6
✖
https://wolfram.com/xid/0b9jl72ytb5t66gqhm-q8i
Applications (1)Sample problems that can be solved with this function
In[1]:=1
✖
https://wolfram.com/xid/0b9jl72ytb5t66gqhm-b18zaj
Process each row individually, and get the sum:
In[2]:=2
✖
https://wolfram.com/xid/0b9jl72ytb5t66gqhm-jvr
In[3]:=3
✖
https://wolfram.com/xid/0b9jl72ytb5t66gqhm-jau
In[4]:=4
✖
https://wolfram.com/xid/0b9jl72ytb5t66gqhm-zc1
Out[4]=4
In[5]:=5
✖
https://wolfram.com/xid/0b9jl72ytb5t66gqhm-xbz
In[6]:=6
✖
https://wolfram.com/xid/0b9jl72ytb5t66gqhm-wb9