To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=81921 Issue #|81921 Summary|[cws dba24a] mysql odbc releations design: error when |close dialog with OK Component|Database access Version|current Platform|All URL| OS/Version|Linux Status|NEW Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|oj Reported by|msc
------- Additional comments from [EMAIL PROTECTED] Tue Sep 25 08:24:16 +0000 2007 ------- I use - Linux - mysql 5.0.18 - mysql-connector-odbc-3.51.20-0 - the tables are create with this SQL command: drop TABLE if EXISTS rel1 ; CREATE TABLE `rel1` ( `id` int(11) NOT NULL, `text_1` varchar(20) default NULL, `text_2` varchar(20) default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; drop TABLE if EXISTS rel2; CREATE TABLE `rel2` ( `id` int(11) NOT NULL, `text_1` varchar(20) default NULL, `text_2` varchar(20) default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; 1. open a database with type mysql and ODBC to connect to the mysql server 2. open TOOLS / RELATIONS 3. add table rel1 and rel2 4. d&d id field from rel1 to rel2 5. double click the relation 6. close the dialog with OK ==>> error messages: You have an error in your SQL syntax: 'CONSTRAINT 'NULL'' --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]