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

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