To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=86395 Issue #|86395 Summary|Copy Table wizard generates invalid statement for ODBC | datasources Component|Database access Version|current Platform|All URL| OS/Version|All Status|NEW Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|atjensen
------- Additional comments from [EMAIL PROTECTED] Sat Feb 23 18:22:04 +0000 2008 ------- OO.o 2.4 RC1 To reproduce: Open an Embedded database file. Open a Base file using an ODBC datasource. ( tested w/ MySQL & SQLite ) Drag a table from the ODBC file to the embedded file. Insure that at least one of the fields being copied is of type TEXT [varchar ] The copy fails with an invalid create statement. When the source was an MySQL databse under Windows XP the statement failed to pick up a size factor. ie CREATE TABLE (..., Varcharfield VARCHAR () When the source was a Kexi databse under Linux the statement failed to close the data size - ie CREATE TABLE (..., VarcharField VARCHAR( 50, NextField..... ) Under 2.3.1 copy table worked correctly for the sources. --------------------------------------------------------------------- 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]