Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index


I created the relationships in MySql like this: http://imgur.com/uWie1g8
InnoDB is the engine


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

Le 13/05/13 06:09, rounak jain a écrit :

Hi,

I have connected MySql to Base. I created some relationships in MySql.
They
are properly visible in the Relationships chart in Base. See image.
http://imgur.com/qtM8fVN,jwvJpen


How did you create your relationships ?
- on the mysql server, with DDL statements ?
- on the LO side, using the graphical UI tools ?
- which db storage engine are you using ? myisam or innodb ?


MyISAM does not enforce foreign key relationships, this has to be
accomplished by the user with programming logic or the UI frontend. If
you are using LO Base, then this can only be enforced via
macro/scripting language, because the UI takes the db driver defaults
and does not enforce either referential integrity or relationships.

Even if you choose a db storage engine that supports referential
integrity and backend controlled relationships, the LO UI currently
"seems to promise" things it can't actually deliver with db backends
other than the builtin hsqldb engine.


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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.