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
