Re: [libreoffice-users] Re: Base: Questions From Potential New User

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: 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