[libreoffice-users] Re: problems with relationships created in MySQL

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