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 Bind command resets value bindings for parameters in a prepared SQL statement.

parameter is the index of the SQL parameter to be set. The leftmost SQL parameter has an index of 1.

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

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

$\mathrm{Execute}\left(\mathrm{connection}\,''CREATE\; TABLE\; test\; (val)''\right)\:$

$\mathrm{stmt}≔\mathrm{Prepare}\left(\mathrm{connection}\,''INSERT\; INTO\; test\; VALUES\; (?)''\right)$

$\mathrm{stmt}≔''SQLite\; statement'',''INSERT\; INTO\; test\; VALUES\; (?)''$

$\mathrm{Bind}\left(\mathrm{stmt}\,1\,''value\; 1''\right)$

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

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

$\mathrm{stmt}≔\mathrm{Prepare}\left(\mathrm{connection}\,''SELECT\; *\; FROM\; test''\right)$

$\mathrm{stmt}≔''SQLite\; statement'',''SELECT\; *\; FROM\; test''$

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

$\left[\begin{array}{c}''value\; 1''\end{array}\right]$

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

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

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

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