SQLiteDatabase.AttachDatabase

From Xojo Documentation

Method

SQLiteDatabase.AttachDatabase(file As FolderItem, databaseName As String[, password As String]) As Boolean

Supported for all project types and targets.

Attaches the SQLite database referred to by file to the database. It gives the newly attached database the name databaseName.

Notes

When a database has been attached, it is possible to do cross-database queries. In order to attach an encrypted database, you must pass the correct password for the database to be attached.

You should prefix all SQL queries to tables in the attached database with the databaseName.