Online Help

valuetype = string or list(string)

The valuetype option specifies the type of the value. It may be one of the strings "auto", "blob", "float", "integer", "text", or a list of those strings. If a list, then the type of a column is specified by the corresponding element in the list; if a string, then it specifies the type of all columns. See the Database[SQLite] help page for more information about type conversion between SQLite and Maple. The default is "auto".

The FetchRow command returns the values of all columns of the current row of a prepared SQL statement.

In order to fetch the next row, call the Step command while it returns RESULT_ROW.

$\mathrm{with}\left(\mathrm{Database}\left[\mathrm{SQLite}\right]\right)\:$

$\mathrm{db}≔\mathrm{FileTools}\left[\mathrm{JoinPath}\right]\left(\left[\mathrm{kernelopts}\left('\mathrm{datadir}'\right)\,''SQLite''\,''G20-Population.db''\right]\right)\:$

$\mathrm{connection}≔\mathrm{Open}\left(\mathrm{db}\right)\:$

$\mathrm{stmt}≔\mathrm{Prepare}\left(\mathrm{connection}\,''SELECT\; date,\; CAN\; FROM\; population\; LIMIT\; 2''\right)$

$\mathrm{stmt}≔''SQLite\; statement'',''SELECT\; date,\; CAN\; FROM\; population\; LIMIT\; 2''$

$\mathrm{Step}\left(\mathrm{stmt}\right)\:$

$\mathrm{FetchRow}\left(\mathrm{stmt}\right)$

$\left[''1960年12月31日''\,1.7909009\times {10}^7\right]$

$\mathrm{Step}\left(\mathrm{stmt}\right)\:$

$\mathrm{FetchRow}\left(\mathrm{stmt}\,'\mathrm{valuetype}'=\left[''integer''\,''text''\right]\right)$

$\left[1961\,''18271000.0''\right]$

$\mathrm{Finalize}\left(\mathrm{stmt}\right)\:$

$\mathrm{stmt}≔\mathrm{Prepare}\left(\mathrm{connection}\,''SELECT\; date,\; CAN\; FROM\; population\; LIMIT\; 10''\right)$

$\mathrm{stmt}≔''SQLite\; statement'',''SELECT\; date,\; CAN\; FROM\; population\; LIMIT\; 10''$

$$\begin{gathered} \mathbf{while}\mathrm{Step}\left(\mathrm{stmt}\right)=\mathrm{RESULT\_ROW}\mathbf{do} \\ \mathrm{print}\left(\mathrm{FetchRow}\left(\mathrm{stmt}\,'\mathrm{valuetype}'=''integer''\right)\right) \\ \mathbf{end}\mathbf{do} \end{gathered}$$

$\left[1960\,17909009\right]$

$\left[1961\,18271000\right]$

$\left[1962\,18614000\right]$

$\left[1963\,18964000\right]$

$\left[1964\,19325000\right]$

$\left[1965\,19678000\right]$

$\left[1966\,20048000\right]$

$\left[1967\,20412000\right]$

$\left[1968\,20744000\right]$

$\left[1969\,21028000\right]$

$\mathrm{Finalize}\left(\mathrm{stmt}\right)\:$

$\mathrm{Close}\left(\mathrm{connection}\right)\:$

The Database[SQLite][FetchRow] command was introduced in Maple 18.

For more information on Maple 18 changes, see Updates in Maple 18 .