To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105872
------- Additional comments from [email protected] Tue Oct 20 09:05:45 +0000 2009 ------- This is my complete transcript of the steps I undertook to create this error on Windows XP (both server and client on the same box). For your convenience, I'm attaching the working directory which I used for the experiment as a .zip archive. 1) Create directory "c:\demo". 2) Deploy hsqldb.jar from http://www.hsqldb.org/support/hsqldb.jar (version: 1.9 post RC6) into "c:\demo". 3) Create runner script "server.bat" with the following content: java -cp hsqldb.jar org.hsqldb.server.Server -database.0 demo/demo -dbname.0 demo 4) Create runner script "client.bat" with the following content: 5) Run server.bat 6) Run client.bat 7) Create the following test table and index CREATE CACHED TABLE product ( id INTEGER IDENTITY PRIMARY KEY, code VARCHAR(50), name VARCHAR(50) ); CREATE INDEX idx_product ON product (code); 8) Insert the following sample data: INSERT INTO product (code,name) VALUES ('001','First product'); INSERT INTO product (code,name) VALUES ('002','Second product'); INSERT INTO product (code,name) VALUES ('003','Third product'); 9) Shut down HSQL in anticipation of OpenOffice installation and system restart by issuing: SHUTDOWN COMPACT; 9) Download OpenOffice 3.2 beta, version OOO320_m2 (OOo 3.2 Beta) from: http://download.services.openoffice.org/files/extended/developer/ OOO320_m2_3.2_beta/OOo-Dev_OOO320_m2_3.2_beta_Win32Intel_install_en-US.exe 10) Purge any old OpenOffice installations by uninstalling them, deleting their user settings directory "C:\Documents and Settings\$USERNAME\Application Data" and restarting the system. 11) Install the new OpenOffice (default, except no QuickStarter). Start Ooo-Dev (not Base). Fill in initials. Do not register. Pick "Tools" > "Options" > "Java". It should show "1.6.0_16" for the VM. Click "Class Path". It should be empty. Click "Add archive", direct it to "C:\demo\hsqldb.jar". Close with OK and close OpenOffice. 12) Start the HSQL server. Select "Connect to an existing database", and pick JDBC for the type. Set "jdbc:hsqldb:hsql://127.0.0.1/demo" as the URL, set "org.hsqldb.jdbcDriver" as the driver class. Test the class, it should load. Supply no password and test the connection, it should establish. Specify "Register the database for me" and "Open the database for editing" and click "Finish". First try saving it as "C:\demo\demo.odb", but fail since HSQL has created a subdirectory "demo", which gets entered instead of saving the file. Try saving as "demo.odf", to get a file created which is named "demo.odf.odb". Answer "no" to the question about the improvement program. Base should finally start up, showing the database namespace "PUBLIC ---> PUBLIC" which contains the table "PRODUCT". 13) Open the table, verify that data is visible. Create a query in SQL view named "product" as "SELECT * FROM PRODUCT". Run query, try to apply standard filter, observe that no field names are offered in the field names menu (ATTN: this might require a separate bug report). Create a form in design view. Click the Form Navigator tool from the toolbar. No forms should be visible in the navigator window. Right-click the root element "FORMS" and select "New" > "Form". A form entry should appear, initially named "Form". Right-click it and select "Properties". Go to the "Data" tab and select the following: Content type: Table. Content: PUBLIC.PUBLIC.PRODUCT Analyze SQL comment: Yes Close the form properties dialog, close the form navigator. Select the text box tool, create a text box on the form. Observe that something is wrong (you cannot place it freely, instead it automatically docks itself to the left edge of the form workspace) but create it anyway. Right-click it and select "Control". In the "Data" tab select "ID" into the "Data Field" listbox. Add two more form fields, selecting "CODE" and "NAME" as their respective data fields. Observe that your ability to place them freely in the form workspace seems haphazard and random (this might require a separate bug report). Finally close the form, save it under the name "formProduct". Now open the form for use, observe that it correctly displays values entered into the table. Try browsing back and forth using navigation buttons, observe that they work. Click the "Form based filters" tool from the toolbar, observe that the filter pop-up toolbar appears. Try entering something into the ID field, observe that it's not possible. Ascertain that the same happens with the CODE and NAME field. ...and that is the essence of the problem for me. No way to enter the keyword to start filtering data. For a change, try switching the data source of the form from "Table" to "SQL Command" and using "SELECT * FROM PRODUCT". Observe that it still displays data, but the filter problem remains. --------------------------------------------------------------------- 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]
