valuetype = string

The valuetype option specifies the type of the value. It may be one of the strings "auto", "blob", "float", "integer", or "text". See the Database[SQLite] help page for more information about type conversion between SQLite and Maple. The default is "auto".

The Fetch command returns the value of a column for the current row.

The column parameter specifies the column index; the leftmost column has index 0.

$\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\; 1''\right)$

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

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

$\mathrm{Fetch}\left(\mathrm{stmt}\,0\right)$

$''1960-12-31''$

$\mathrm{Fetch}\left(\mathrm{stmt}\,1\right)$

$1.7909009\times {10}^7$

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

$$\begin{gathered} \mathbf{for}\mathrm{vt}\mathbf{in}\left[''auto''\,''blob''\,''float''\,''integer''\,''text''\right]\mathbf{do} \\ \mathrm{Step}\left(\mathrm{stmt}\right); \\ \mathrm{print}\left(\mathrm{vt}\,\mathrm{Fetch}\left(\mathrm{stmt}\,0\,'\mathrm{valuetype}'=\mathrm{vt}\right)\right); \\ \mathrm{print}\left(\mathrm{vt}\,\mathrm{Fetch}\left(\mathrm{stmt}\,1\,'\mathrm{valuetype}'=\mathrm{vt}\right)\right); \\ \mathrm{Reset}\left(\mathrm{stmt}\right) \\ \mathbf{end}\mathbf{do} \end{gathered}$$

$''auto'',''1960-12-31''$

$''auto'',1.7909009\times {10}^7$

$''blob'',\left[\begin{array}{cccccccccc}49& 57& 54& 48& 45& 49& 50& 45& 51& 49\end{array}\right]$

$''blob'',\left[\begin{array}{cccccccccc}49& 55& 57& 48& 57& 48& 48& 57& 46& 48\end{array}\right]$

$''float'',1960.$

$''float'',1.7909009\times {10}^7$

$''integer'',1960$

$''integer'',17909009$

$''text'',''1960-12-31''$

$''text'',''17909009.0''$

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

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

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

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