LO Base and Sqlite Setup

[ggk]

Win10, LO7.2.x,sqlite 3.35.5

Hi,

Can connect base to Chinook.db via odbc with no problems. However I do not seem to be able to attach an additional db to the current connection.

If I run SQL - attach database ‘c:\sqlite\dbs\contacts.db’ as contacts; - message reads ok, but the tables of the contacts db do not show in base, whereas they do show in db browser and in python command line, after which I can quiry the contacts db tables within the Chinook connection.

Is this a bug or am I missing something?

Thanks for any pointers.

[Wanderer]

Have you tried to create a query with “direct sql” active?

If you check your picture the attached db is not at the same level as the “original” chinook tables. So I assume the GUI of Base will not “see” the attached table, but sql may be possible.

Have not tried this before…

[Ratslinger]

Hello,
Base is not displaying the tables for attached DB. However, the DB tables are available for processing.
.
Currently tested on Ubuntu 20.04.

[ggk]

Thank you, yes its there, just have to remember table and fieldnames.

[ggk]

Thanks, yes sql does see the attachment.

[Ratslinger]

@ggk

just have to remember table and fieldnames.

My preference is to list using SQL > How can I list the tables in a SQLite database file that was opened with ATTACH?

[ggk]

Thank you for the link, that’s great!

[Wanderer]

@ggk

just have to remember table and fieldnames.

or use a fixed prefix like AS att for the attached database so the following should work:

SELECT name FROM att.sqlite_master 

[ggk]

Thank you, working perfectly.