Application icon

Referencing Query Databases

All query database action statements have a field where you specify the Database Name. This field identifies the database with which you wish to interact. The field can be specified in a number of ways.

Note. it is strongly recommended that you use the prefix, explicit or empty, when you opened the database as the identifier. At some point other methods will more than likely be removed.

Example:

You can access the opened database via any of the following:

empty
Assuming there is only one query database open.
/path/mydb.csv
The actual path.
\<MyDB-Path>
Unescape the named variable which contains the path.
MyDB
The prefix supplied on the Open statement./dd>
\v1
Assuming Variable 1 contains either /path/mydb.csv or MyDB.

Note that the Query Database field in all Query Database statements will be preset to a database identifier if there is one and only one Open Database for Querying statement (in all open actions) which specifies a prefix. There is also an Insert Query Database Prefix context menu for these fields to pick from any used prefixes.