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
What kind of issue would you like to report? (Optional)