Le 16/01/2015 17:00, Rich Shepard a écrit :
The schema has 18 tables (including many-to-many intermediate tables) and
numerous foreign key references; more may be added. Will Base handle this
You don't say whether your users will be just reading, or reading from
and writing to the database.
I imagine that reading should be alright, you might have issues with
multiple cascading table updates, that would depend on the SQLite driver
no doubt. Also be aware that SQLite timestamps and datetime data are
incorrectly handled by Base as far as I recall.
The DDL text file (using sqlite syntax) is approximately 200 lines. Can
this be imported into Base so I do not need to re-key each line to create
the tables and relationships?
The easiest way to do this might be to set up an empty ODB that connects
to your SQlite file via a driver, then after loading the ODF file use
Tools > SQL and copy in your DDL statement into the SQL window.
To unsubscribe e-mail to: firstname.lastname@example.org
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
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy