reset prepared statement
Reset( statement, clear )
prepared statement obtained using Prepare command
clear all bound values, default is false
The Reset command resets the prepared SQL statement so that it can be executed again.
When clear = true is passed, ClearBindings is also called after the statement is reset.
db ≔ FileToolsJoinPath⁡kernelopts⁡'datadir',SQLite,G20-Population.db:
connection ≔ Open⁡db:
Select data from table - prepare statement
stmt ≔ Prepare⁡connection,SELECT * FROM population
stmt≔SQLite statement,SELECT * FROM population
Fetch all rows
Reset the statement and select data again
The Database[SQLite][Reset] command was introduced in Maple 18.
For more information on Maple 18 changes, see Updates in Maple 18.
Download Help Document
What kind of issue would you like to report? (Optional)