[libreoffice-users] Re: LO 4.0: intrinsic database: relations only between primaries keys?

On 02/11/2013 11:31 PM, Uwe Brauer wrote:

Hi Uwe,

> As I said, in another mail,  when I connect the data base to mysql via
> ODBC then I can set more relations, but they are not saved..

I take it that you are using InnoDB engine in your mysql db ?

Otherwise, e.g. if you are using myisam or heap as the default engine,
relations are not supported by mysql, i.e. they are not enforced
(although they can be stored as a textual reference).

This is true whether you are using ODBC, JDBC or the native mysql
connector to reach your tables from within LO.


Alex


-- 
For unsubscribe instructions e-mail to: users+help@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