Well, found the solution.
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. 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?
Andrew
Andrew Jensen wrote:
.........
Now open a new query window in SQL view, add the following select
statement.
SELECT CASE DATA WHEN 'xxxx' THEN 'X' WHEN 'yyyy' THEN 'Y' WHEN 'zzzz'
THEN 'Z' ELSE 'NOTFOUND' END FROM TESTCASE
Run the query. I get are three rows with NULL values.
...............
---------------------------------------------------------------------
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]
