[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 <[email protected] > 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: [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 > > -- 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
