Database[SQLite]
Reset
reset prepared statement
Calling Sequence
Parameters
Description
Examples
Compatibility
Reset( statement, clear )
statement
-
prepared statement obtained using Prepare command
clear
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.
with⁡DatabaseSQLite
Attach,Bind,ClearBindings,Close,ColumnCount,ColumnNames,Execute,Fetch,FetchAll,FetchRow,Finalize,Open,Opened,Prepare,RESULT_BUSY,RESULT_DONE,RESULT_ROW,Reset,Step
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
FetchAll⁡stmt
Reset the statement and select data again
Reset⁡stmt:
Finalize⁡stmt:
Close⁡connection:
The Database[SQLite][Reset] command was introduced in Maple 18.
For more information on Maple 18 changes, see Updates in Maple 18.
See Also
Database[SQLite][ClearBindings]
Download Help Document
What kind of issue would you like to report? (Optional)