On Fri, 16 Jan 2015, Alex Thurgood wrote:
You don't say whether your users will be just reading, or reading from and writing to the database.
Alex, Reading and writing.
Also be aware that SQLite timestamps and datetime data are incorrectly handled by Base as far as I recall.
That's interesting. Will have to look for problems.
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.
That copying is what I was hoping to avoid. I'll create the sqlite db, then see if I can connect to it via a sqlite-odbc driver. Should be one that will work. Thanks, Rich -- To unsubscribe e-mail to: [email protected] 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
