[libreoffice-users] Re: Base: Connecting to SQLite3 .db and Working With it

Am 18.01.2015 um 18:43 schrieb Rich Shepard:



>   Than, when I clicked the 'Finish' button I get a LO save dialog with the
> default name of 'New Database' (with a space that needs to be removed, no
> less!). If I give it a name, does the new *.odb contain the schema and data
> of the existing sqlite3 .db? I apparently cannot use File -> Open on the
> .db
> file; it produces a Write page with hash symbols on it.

Your tables, relations, indices and data are still in the SQLite.db file
and handled by the ODBC driver. The so called Base document is just a
configuration file with optional queries, forms and reports. It is
bridge between SQLite and office documents.
With a registered database you can use database data in arbitrary office
documents for mail merge, label printing, bibliographies and as a data
source of calculation models.

In Calc or Writer hit F4 and you see the registered databases. With
unregistered databases you can only use the forms and reports that are
embedded in that "database document".


-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted