To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=107224 Issue #|107224 Summary|after copying a table with data, can not open due to " |unknown column in order clause" Component|Database access Version|OOO310m19 Platform|PC URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|timrichardson
------- Additional comments from timrichard...@openoffice.org Thu Nov 26 01:18:59 +0000 2009 ------- I have a table pupil I do a copy and paste to create pupil2 (appending data) Then I double click the new table to open it. I get an error 'unknown column' 'pupil.file_nbr' in 'order.clause' file_nbr is the one field in the primary key. It has "ascending sort order". I suspect that when copying the table, the reference to pupil.file_nbr is not renamed to pupil2.file_nbr the "more information" dialog box tells me The SQL command leading to this error is: SELECT * FROM `bellevue_kinder`.`pupil2` ORDER BY `pupil`.`file_nbr` --------------------------------------------------------------------- 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: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
