To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=95880
------- Additional comments from [EMAIL PROTECTED] Sat Nov 22 14:12:34 +0000 2008 ------- Tested on systems OO.o 2.4.1 (Ubuntu supplied version) and OO.o 3.0 (OpenOffice.org distro) - both on Ubuntu 8.10 (x64) and SUN JRE 1.0.6_10 Two parts here - First the create view statement for the view Current Retail Override Prices" 2.4.1, this fails with the same error you get no matter if it is in the SQL window or via the GUI create view window 3.0 is excepted and executes as expected Second part - the attached file of sql commands - when run in a SQL window it fails in both 2.4.1 and 3.0 - it fails in different spots depending on which version of OO.o is run. In the case of using 3.0 it appears that it is a syntax error (typo I think) in the create view statement for the view "Retail Sales Unit Masses", of course under 2.4.1 it didn't get far enough to show this as a 'column not found' error. So - I don't have a copy of vanilla version of 2.4.1 for Linux installed to test this on - will be installing a 2.4.2 vanilla version later and can check then - but at first blush looks like it could be either vendor specific (if you are running a vendor supplied copy of OO.o) or something that has been fixed in the current 3.0 release anyway. --------------------------------------------------------------------- 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]
