Database[SQLite]
Finalize
finalize a prepared SQL statement
Calling Sequence
Parameters
Description
Examples
Compatibility
Finalize( statement )
statement
-
prepared SQL statement obtained using the Prepare command
The Finalize command finalizes a prepared SQL statement.
with⁡DatabaseSQLite:
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
Finalize the statement
Finalize⁡stmt:
Close⁡connection:
The Database[SQLite][Finalize] command was introduced in Maple 18.
For more information on Maple 18 changes, see Updates in Maple 18.
Download Help Document