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