To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115398 Issue #|115398 Summary|copytablewizard: integer fields from MS Access are cre |ated autoincrement or double in ODBC Component|Database access Version|OOO330m13 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|ludob
------- Additional comments from [email protected] Thu Nov 4 10:13:00 +0000 2010 ------- Copy a MS Access table containing integer fields to an ODBC connected database (tested with mysql, mssql driver). All integers are created as autoincrement (mysql) or identity (mssql) independent of the "AutoValue" field in the source. Mysql and mssql don't accept multiple autoincrement/identity fields in the same table. Mssql requires also a "SET IDENTITY_INSERT table ON" to insert identity fields. Using the oracle ODBC driver, integers are all converted to BINARY_DOUBLE (Oracle 10). Test file attached. --------------------------------------------------------------------- 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]
