The Language Ref does not seem to have any documentation of these attributes of an SQLiteDatabase, but AutoComplete shows them, along with values
MainDatabase (value=“Main”), which I assume is the “schema” name for the main database, or the database that attached databases are (uh) attached to
In regards to an “attached” database… you “attach” to the main database using
If currentDB.AttachDatabase(attachDBFile, "locations") Then
but how do you tell if or how many attachments have been made… and what the “schema” name (ie. “locations” in the example) are?
or do you have to create a array/table/collection of these manually?
Thank you Emile, but those do not address the question…
It is not how to connect to a database, nor how to attach a 2nd (3rd, etc) database to the original connection.
The question is how to determine the SCHEMA name that the user supplied when an attachment was made, and to track (and use) that name during subsequent SQL activities.
For now I have created a class that creates a dictionary of that information… but was hoping that the database class itself handled that.
This pragma works like a query to return one row for each database attached to the current database connection. The second column is the “main” for the main database file, “temp” for the database file used to store TEMP objects, or the name of the ATTACHed database for other database files. The third column is the name of the database file itself, or an empty string if the database is not associated with a file.