[libreoffice-users] Re: help with database

Le 12/05/13 18:41, Tom Davies a écrit :

Hi Tom, all,

> Wow!!!  That sounds good :)
> Thanks Ian.  

Unfortunately not true. There are mysql objects you can not create from
within LO Base, even if you have already got one table defined.

An example : try creating a table with a tinyint autoincrement field in
LO Base using mysql backend and see if your table definition
sticks/works properly - it doesn't (or at least it didn't last time I
tried).

Try adding a field to an existing table at the position where you want
it - it won't work.

Try defining DEFAULT values using mysql builtin functions (e.g.
CURRENT_USER) in your fields via LO - that won't work.

Try defining a view using CAST statements in LO and watch it fail
because there's a mismatch between what LO promises and what it can
actually do.

For all of these things and more, you need to know how to manipulate the
mysql backend from the command line or from a graphical UI tool, such as
mysqlnavigator (Linux), or MySQL Workbench (multi-OS graphical tool for
managing and manipulating your mysql servers and data)

LO Base is not FMPro (unfortunately), nor Access, not Lotus Approach,
and I seriously doubt that it ever will be.

If you are working on Mac, as the original poster seems to be, the
situation is even less evident for the user who has been used to working
with FMPro. FMPro is user friendly, and even Bento is user-friendlier
than LO Base, but FMPro now costs you an arm and a bloody leg, and Bento
is not for networked, multi-user sharing (at least from what I have seen
so far).



Alex


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