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
Context
- [libreoffice-users] LO 4.0, mysql database, odbc server relations are not saved · Uwe Brauer
Privacy Policy |
Impressum (Legal Info) |
Copyright information: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License.
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (
MPLv2).
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our
trademark policy.