To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=73021 Issue #|73021 Summary|Sub Form Fails to use IDENTITY values of type INTEGER |(MySQL 5.0) Component|Database access Version|OOo 2.1 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|robyooo
------- Additional comments from [EMAIL PROTECTED] Sun Dec 31 09:40:24 -0800 2006 ------- Connecting to an InnoDB MySQL 5.0 database using ODBC driver 3.51.12.00, a table created using a primary key of type INTEGER UNSIGNED NOT NULL AUTO_INCREMENT will pass the value to linked subform based on another table but when you try to save the record in the subform the linked value in subform becomes "0" and then OOo crashes. Using a primary key of type SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT solves the problem. --------------------------------------------------------------------- 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]