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] Thu Nov 6 20:50:23 +0000 2008 ------- Correction: it looks like this isn't a java bug. I'm still using the Sun Java VM, and I've gotten the same error again. To reproduce the bug I first did DROP VIEW "Current Business Rules" CASCADE in Tools->SQL, then restarted OpenOffice Database, and entered a series of commands into Tools->SQL, all in one big chunk, by copy-pasting the entirety of the second attached file (current_business*.script.sql). When I did that, the first CREATE VIEW statement ("Current Business Rules") executed successfully. The second CREATE VIEW statement, to create the view "Current Retail Override Prices", caused the same error as before (...StringIndexOutOfBoundsException ... "begin > end"...). Subsequent attempts to execute this statement, even with other statements removed from the Tools->SQL textbox, failed for the same reasons. I saved the database, exited OpenOffice, and reopened my database. I copy-pasted the commands over again and deleted the first command and the comment so that the string of commands started with CREATE VIEW "Current Retail Override Prices". Clicking Execute at this point successfully executed that command and created the view. The rest of the commands were also accepted, though of course I had to take out the ones for already-existing views. Although there are some very long commands in the list, the one causing the problem is completely on one line, and that line is a lot longer than any other lines in the script. The reconstructed database is working okay. --------------------------------------------------------------------- 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]