Application icon

Is Database Open

This function is used to determine if a specified database is open.

The path may contain any of the escape sequences described in Escape Sequences. At runtime, the path to a database must be absolute (/) or relative to the home folder (~/) and must have a filename extension of .csv, .tsv or .tab.

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.