To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=75557
------- Additional comments from [EMAIL PROTECTED] Fri Apr 27 06:35:40 +0000 2007 ------- 1. File/New/Spreadsheet 2. Rename the 1st worksheet to "Tabelle1". Enter the following data |A|B|C| <-row 1 |1|2|3| <-row 2 3. Save as foo.ods 4. File/New/Database 5. Connect to existing db, type: Calc Spreadsheet 6. Choose foo.ods as source 7. Finish 8. Save as dialog opens automatically. Enter name "foo" for the database 9. Queries/Create new SQL query 10. Copy'n'paste the query from my report 11. Save (choose any name for the query) 12. Close SQL window 13. Double-click on the new query 14. Invalid statement message pops up. To verify that the same query works for HSQL databases 1. File/New/Database 2. Create new database 3. Create a new table with columns A, B and C. Name the table "Tabelle1" 4. Create a new SQL query as above. 5. Double-click the statement => Works --------------------------------------------------------------------- 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]
