Database[SQLite] - Maple Programming Help

Online Help

All Products    Maple    MapleSim


Home : Support : Online Help : Connectivity : Database Package : SQLite : Database/SQLite/Opened

Database[SQLite]

  

Opened

  

List Opened Databases

 

Calling Sequence

Parameters

Description

Examples

Compatibility

Calling Sequence

Opened( connection )

Parameters

connection

-

database connection obtained using Open command

Description

• 

The Opened command returns a table that lists all opened databases for the given connection. Key in the table is the name of the database and value is the file name.

• 

For in memory or temporary databases the file name is an empty string.

Examples

withDatabaseSQLite

Attach,Bind,ClearBindings,Close,ColumnCount,ColumnNames,Execute,Fetch,FetchAll,FetchRow,Finalize,Open,Opened,Prepare,RESULT_BUSY,RESULT_DONE,RESULT_ROW,Reset,Step

(1)

dbFileToolsJoinPathkernelopts'datadir',SQLite,G20-Population.db:

connectionOpendb

SQLite database,tablemain=C:\Program Files\Maple 2019\data\SQLite\G20-Population.db

(2)

Create and attach another in memory database

Attachconnection,:memory:,database2:

Opened databases

Openedconnection

SQLite database,tabledatabase2=,main=C:\Program Files\Maple 201\data\SQLite\G20-Population.db

(3)

Closeconnection

SQLite database: connection closed

(4)

Compatibility

• 

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

• 

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