Hi Andrew. > Change the select statement to > > SELECT CASE DATA WHEN 'xxxx' THEN 'X' WHEN 'yyyy' THEN 'Y' WHEN 'zzzz' > THEN 'Z' ELSE 'NOTFOUND' END AS "DATA" FROM TESTCASE > > > It still requires that EscapeProcessing = false.
The HSQLDB engine is capable of more things that OOo's cross-DB parser, and SELECT CASE is not part of the latter. > With the change > (explicity setting the return columns name ) it works correctly using a > RowSet object via the API, and as a View also. > > Still, is this an issue I should enter? Hmm, not sure without looking deeper into it. Might be possible that we can make OOo tolerant enough to also properly execute the AS-less query, so fel free to submit an issue (though it would probably be P4), so we can investigate. Thanks & Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Database http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
