Re: [libreoffice-users] Re: help with database

[quote]FMPro is user friendly, and even Bento is user-friendlier
than LO Base, but FMPro now costs you an arm and a bloody leg[/quote]
My feelings too. Thats what made me look for an alternative. But Base has
begun to disappoint me if all this is STILL true:
http://forum.openoffice.org/en/forum/viewtopic.php?f=61&t=6025#p53756


On Mon, May 13, 2013 at 4:34 PM, Alexander Thurgood <alex.thurgood@gmail.com
> wrote:

> 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

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