To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=70160
------- Additional comments from [EMAIL PROTECTED] Fri Mar 9 09:21:03 +0000 2007 ------- Tested this under 2.2RC2. The issue still exists. If you open the example database and enter SELECT * INTO "foo" FROM "abc" in the SQL window you can then create a query in designer of select * from "foo", all of the data is retrieved. Close the database file and open it again, the table is now visible but all of the data is gone. Open the SQL window and enter this command instead. SELECT * INTO CACHED "foo_c" FROM "abc" Now, View>Refresh Tables will list the table. One more time open the SQL window and enter CREATE TEMPORARY TABLE "bar" ( ID INTEGER, NAME VARCHAR(50) ) ON COMMIT PRESERVE ROWS; INSERT INTO "bar" VALUES( 0, 'Drew' ); SELECT COUNT( ID ) FROM "bar"; The commands execute successfully. Again the table can not be seen, even after table refresh. In a query design window enter SELECT * from "bar", you will get back 1 record. Close and reopen the database file in the SQL window enter the CREATE statement again..this time it fails. The table "bar" still exist in the database, but it is still invisible. OK, one last oddity here. When the table is created with the Select into command it is initialy invisible, all of the data is available however. Close and open the database and the table is now visible, but the data is gone. Add some data to the table now, using an insert statement in the SQL window (since the table has no PK), close and open the database and voila the data is now retained. ??? --------------------------------------------------------------------- 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]
