I'm attempting to include a case expression in an SQL Command (using the Database Expert popup), but I'm receiving an error. Other queries work as expected.
I'm using Crystal Reports 2011 on Windows 7.
select case when dummy = 'X' then 1 else 2 end from dual;
Failed to retrieve data from the database Details: HY000:[Oracle][ODBC][Ora]ORA-00933: SQL Command not properly ended [Database Vendor Code: 933 ]
Could you tell me what syntax I need to use for a case expression please? (Also, is there a syntax guide for the version of SQL used by Crystal Reports Commands?)