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+unsubscr...@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
