To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=66905 Issue #|66905 Summary|Copy table's "append data" does not put data in proper | fields Component|Database access Version|OOo 2.0.3 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|rbmatt
------- Additional comments from [EMAIL PROTECTED] Fri Jun 30 15:43:39 -0700 2006 ------- You are able to append data to a table by dragging and dropping from a Calc document. This opens the Copy Table dialog where you can select Append data. If you give the name of the table you want to append to, the next screen shows the dragged fields beside the table's fields. You should be able to reorder the right side so that the fields match up correctly. This apparently has no effect. The data is imported into the fields sequentially, even if datatypes do not match up correctly (it will try to put VARCHAR into an INT). The attached zip file contains 2 OOo files to test for replication. Open the database and click the tables icon. Open the Calc document and range-select all the cells with data. Click and drag this over to the database application and drop it in the area that lists the table. Select "Append data" and enter "Contacts" as the table name. Click next. Click the up buttons so that Name and Phone are the first two fields. Press Create and see the error. It tries to insert into "id","Name" instead of "Name","Phone" as expected. --------------------------------------------------------------------- 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]
