[libreoffice-users] LO 4.0, mysql database, odbc server relations are not saved

Hello


(It seems that my message did not pass to the gmane newserver, that is
why I resend this message)

I am using LO 4.0 (I tried also 3.6 and OO 3.3 with the same result)


I am on Kubuntu 10.04, mysql-server, client  5.1.63, odbc 2.2.11
libmyodbc 3.51.27.

So I first create using mysql commands a database called testmysql.
I test the connection via mysqlcheck -u oub -p testmysql.

Everything works fine. I set up the odbc driver, and my .odbc.ini file.

I now use base to create a new database, where I connect to the mysql
server using the odbc driver, test the driver, everything is fine.

I  created two tables using the
templates: one is Task (from business) the other Accounts (from
personal). All the field values are the default ones.  I use an existing
field as a primary key (autovalue on), namely TaskId (numeric) and
AccountId (numeric). I insert some data and save them.


I then set up a relation between the two tables, where I relate the
fields corresponding to the primary keys. (TaskId-->AccountId) I save
the relation and reopen it.

But now the relation ship is gone, it has not been saved.
Is this a bug?

Any help would be appreciated


Uwe Brauer 


-- 
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