clear = truefalse

True means clear all bound values by calling ClearBindings after the statement is reset. The default is false.

The Reset command resets a prepared SQL statement so that it can be executed again.

$\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\; *\; FROM\; population''\right)$

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

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

$\begin{array}{c}\left[\begin{array}{ccccccccccc}''1960-12-31''& 1.80671000\times {10}^8& 6.67070000\times {10}^8& 9.2500572\times {10}^7& 7.2814900\times {10}^7& 4.6637746\times {10}^7& 7.2775883\times {10}^7& 5.2400000\times {10}^7& 5.0199700\times {10}^7& 1.19897000\times {10}^8& \dots \\ ''1961-12-31''& 1.83691000\times {10}^8& 6.60330000\times {10}^8& 9.4943000\times {10}^7& 7.3377632\times {10}^7& 4.7293811\times {10}^7& 7.4988037\times {10}^7& 5.2800000\times {10}^7& 5.0536350\times {10}^7& 1.21236340900000006\times {10}^8& \dots \\ ''1962-12-31''& 1.86538000\times {10}^8& 6.65770000\times {10}^8& 9.5832000\times {10}^7& 7.4025784\times {10}^7& 4.7990159\times {10}^7& 7.7286629\times {10}^7& 5.3250000\times {10}^7& 5.0879450\times {10}^7& 1.22590643400000006\times {10}^8& \dots \\ ''1963-12-31''& 1.89242000\times {10}^8& 6.82335000\times {10}^8& 9.6812000\times {10}^7& 7.4714353\times {10}^7& 4.8697015\times {10}^7& 7.9643017\times {10}^7& 5.3650000\times {10}^7& 5.1252000\times {10}^7& 1.23960074400000006\times {10}^8& \dots \\ ''1964-12-31''& 1.91889000\times {10}^8& 6.98355000\times {10}^8& 9.7826000\times {10}^7& 7.5318337\times {10}^7& 4.9361165\times {10}^7& 8.2017016\times {10}^7& 5.4000000\times {10}^7& 5.1675350\times {10}^7& 1.25344802900000006\times {10}^8& \dots \\ ''1965-12-31''& 1.94303000\times {10}^8& 7.15185000\times {10}^8& 9.8883000\times {10}^7& 7.5963695\times {10}^7& 4.9945471\times {10}^7& 8.4379369\times {10}^7& 5.4348050\times {10}^7& 5.2112350\times {10}^7& 1.26745000\times {10}^8& \dots \\ ''1966-12-31''& 1.96560000\times {10}^8& 7.35400000\times {10}^8& 9.9790000\times {10}^7& 7.6600311\times {10}^7& 5.0430631\times {10}^7& 8.6721875\times {10}^7& 5.4648500\times {10}^7& 5.2519000\times {10}^7& 1.27468492900000006\times {10}^8& \dots \\ ''1967-12-31''& 1.98712000\times {10}^8& 7.54550000\times {10}^8& 1.00725000\times {10}^8& 7.6951336\times {10}^7& 5.0829214\times {10}^7& 8.9052356\times {10}^7& 5.4943600\times {10}^7& 5.2900500\times {10}^7& 1.28196115799999997\times {10}^8& \dots \\ ''1968-12-31''& 2.00706000\times {10}^8& 7.74510000\times {10}^8& 1.01061000\times {10}^8& 7.7294314\times {10}^7& 5.1175036\times {10}^7& 9.1377490\times {10}^7& 5.5211700\times {10}^7& 5.3235750\times {10}^7& 1.28927892099999994\times {10}^8& \dots \\ ''1969-12-31''& 2.02677000\times {10}^8& 7.96025000\times {10}^8& 1.03172000\times {10}^8& 7.7909682\times {10}^7& 5.1518731\times {10}^7& 9.3709914\times {10}^7& 5.5441750\times {10}^7& 5.3537950\times {10}^7& 1.29663845500000000\times {10}^8& \dots \\ ⋮& ⋮& ⋮& ⋮& ⋮& ⋮& ⋮& ⋮& ⋮& ⋮& \end{array}\right]\\ \hfill \text{53 × 21 Matrix}\end{array}$

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

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

$\begin{array}{c}\left[\begin{array}{ccccccccccc}''1960-12-31''& 1.80671000\times {10}^8& 6.67070000\times {10}^8& 9.2500572\times {10}^7& 7.2814900\times {10}^7& 4.6637746\times {10}^7& 7.2775883\times {10}^7& 5.2400000\times {10}^7& 5.0199700\times {10}^7& 1.19897000\times {10}^8& \dots \\ ''1961-12-31''& 1.83691000\times {10}^8& 6.60330000\times {10}^8& 9.4943000\times {10}^7& 7.3377632\times {10}^7& 4.7293811\times {10}^7& 7.4988037\times {10}^7& 5.2800000\times {10}^7& 5.0536350\times {10}^7& 1.21236340900000006\times {10}^8& \dots \\ ''1962-12-31''& 1.86538000\times {10}^8& 6.65770000\times {10}^8& 9.5832000\times {10}^7& 7.4025784\times {10}^7& 4.7990159\times {10}^7& 7.7286629\times {10}^7& 5.3250000\times {10}^7& 5.0879450\times {10}^7& 1.22590643400000006\times {10}^8& \dots \\ ''1963-12-31''& 1.89242000\times {10}^8& 6.82335000\times {10}^8& 9.6812000\times {10}^7& 7.4714353\times {10}^7& 4.8697015\times {10}^7& 7.9643017\times {10}^7& 5.3650000\times {10}^7& 5.1252000\times {10}^7& 1.23960074400000006\times {10}^8& \dots \\ ''1964-12-31''& 1.91889000\times {10}^8& 6.98355000\times {10}^8& 9.7826000\times {10}^7& 7.5318337\times {10}^7& 4.9361165\times {10}^7& 8.2017016\times {10}^7& 5.4000000\times {10}^7& 5.1675350\times {10}^7& 1.25344802900000006\times {10}^8& \dots \\ ''1965-12-31''& 1.94303000\times {10}^8& 7.15185000\times {10}^8& 9.8883000\times {10}^7& 7.5963695\times {10}^7& 4.9945471\times {10}^7& 8.4379369\times {10}^7& 5.4348050\times {10}^7& 5.2112350\times {10}^7& 1.26745000\times {10}^8& \dots \\ ''1966-12-31''& 1.96560000\times {10}^8& 7.35400000\times {10}^8& 9.9790000\times {10}^7& 7.6600311\times {10}^7& 5.0430631\times {10}^7& 8.6721875\times {10}^7& 5.4648500\times {10}^7& 5.2519000\times {10}^7& 1.27468492900000006\times {10}^8& \dots \\ ''1967-12-31''& 1.98712000\times {10}^8& 7.54550000\times {10}^8& 1.00725000\times {10}^8& 7.6951336\times {10}^7& 5.0829214\times {10}^7& 8.9052356\times {10}^7& 5.4943600\times {10}^7& 5.2900500\times {10}^7& 1.28196115799999997\times {10}^8& \dots \\ ''1968-12-31''& 2.00706000\times {10}^8& 7.74510000\times {10}^8& 1.01061000\times {10}^8& 7.7294314\times {10}^7& 5.1175036\times {10}^7& 9.1377490\times {10}^7& 5.5211700\times {10}^7& 5.3235750\times {10}^7& 1.28927892099999994\times {10}^8& \dots \\ ''1969-12-31''& 2.02677000\times {10}^8& 7.96025000\times {10}^8& 1.03172000\times {10}^8& 7.7909682\times {10}^7& 5.1518731\times {10}^7& 9.3709914\times {10}^7& 5.5441750\times {10}^7& 5.3537950\times {10}^7& 1.29663845500000000\times {10}^8& \dots \\ ⋮& ⋮& ⋮& ⋮& ⋮& ⋮& ⋮& ⋮& ⋮& ⋮& \end{array}\right]\\ \hfill \text{53 × 21 Matrix}\end{array}$

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

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

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

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