Application icon

Open Database Information

This function is used to return information on all open databases. ie. those open in the UI and those open as query databases.

The List of Open Databases named variable will contain a list of the paths of each open (non query) database. The list items are separated by the default list delimiter (\~).

The Status of Open Databases named variable will contain a list of character codes describing each (non query) database's status. The list items are separated by the default list delimiter (\~). Each list item can contain the following character codes.

T
The associated database is a Track database.
A
The associated database is an Album database.
S
The associated database is a standalone database.
G
The associated database is currently grabbed. ie. it is associated with a query database.
B
The associated database is busy. It is performing a lengthy operation or has a displayed sheet.
K
The associated database is key. ie. it is the window with focus.
M
The associated database has unsaved changes. ie. it has been modified.
L
The associated database is locked.
R
The associated database is readonly. This can only be set by a query database.
H
The associated database is transient. This can only be set by an action. Note that the R status will also be set.
/
If a database is transient and was opened with a valid path in named variable Transient Database Path, the / will be followed by the specified path. This code will always come last.

The List of Open Query Databases named variable will contain a list of the named variable prefix of each open query database. Note that an empty prefix will appear as Query Database. The list items are separated by the default list delimiter (\~).

The Status of Open Query Databases named variable will contain a list of character codes describing each query database's status. The list items are separated by the default list delimiter (\~). Each list item can contain the following character codes.

C
Keys are case insensitive.
D
Keys are diacritic insensitive.
G
A UI based database is being grabbed.
M
The query database has unsaved changes. ie. it has been modified.
Kinteger
This code is always present and is always second to last in the list item. The integer is the resolved column number of the key column (0 based) or -1 for keyless.
path
This code is always present and is always the last in the list item. It always follows Kinteger. The path will have been resolved and always starts with a / character.