To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=70158
------- Additional comments from [EMAIL PROTECTED] Fri Oct 6 08:05:20 -0700 2006 ------- A follow up on this. The records are copied to the new table, until the file is closed and reopened. Then the table is empty. To see this. Create a new embedded database. Create a new table, Table1. Any columns you like. Add a few records. Now opent the SQL window. Issue the command - SELECT * INTO "Table2" FROM "Table1". Execute the command, close the SQL window. Although the table is not visible it is there. Go to the Query section. Create a new query in SQL view: SELECT * FROM "Table2" Execute the query and all the records from Table1 are now in Table2. Save the query as Query1 Close the Base file and reopen it. Execute the saved query Query1. No records are returned. Open the table Table2, it is now empty. --------------------------------------------------------------------- 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]
