https://bugs.documentfoundation.org/show_bug.cgi?id=138715
--- Comment #38 from Andreas Säger <[email protected]> --- This is how I use Thunderbird's SQLite address books: 1. Shutdown TB before conencting Base. 2. Locate the wanted address book in the TB profile directory. abook.sqlite contains the "personal addressbook". abook-1, abook-2 contain custom address books. history.sqlite contains the "Collected Addresses". 3a) Connect via JDBC with Edit>Database>Advanced... "Respect row set type of the driver"= ON 3b) Connect via ODBC with Edit>Database>Advanced... "Respect row set type of the driver"= OFF 4. Store the Base document under a name comprising the TB address book name. For instance: abook.sqlite = Personal_JDBC_TB.odb abook-1.sqlite = Professional_JDBC_TB.odb (a cusotom address book). collected.sqlite = Collected_JDBC_TB.odb (collected addresses) 5. Add queries and forms from another TB address book. You can use the same set of queries and forms for all TB address books. I'll attach 2 samples for ODBC and JDBC. Query "_MAIN" returns a record set with all availlable fields in normalized form. -- You are receiving this mail because: You are the assignee for the bug.
