The ClearBindings command resets value bindings for parameters in a prepared SQL statement.

$\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{Reset}\left(\mathrm{stmt}\right)$

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

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

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

$\mathrm{Bind}\left(\mathrm{stmt}\,1\,''value\; 2''\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''\\ ''value\; 1''\\ ''value\; 2''\end{array}\right]$

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

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

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

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