Skip to Content
0
Former Member
Mar 23, 2015 at 06:13 PM

Can't Include Case Expressions in Commands

162 Views

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.

Command example:

select case when dummy = 'X' then 1 else 2 end from dual;

Error:

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?)

Thanks